Search:

Type: Posts; User: Supershoe; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    14
    Views
    235

    There is always less confusion when you attach a...

    There is always less confusion when you attach a file with before/after examples along with the logic you provided.
  2. Replies
    14
    Views
    235

    Why dummy sheets?? =SUM(WK1:WK13,D4)

    Why dummy sheets??

    =SUM(WK1:WK13,D4)
  3. Replies
    8
    Views
    184

    Here is part of a double_click event to goto...

    Here is part of a double_click event to goto yahoo finance for the symbol clicked.

    ActiveWorkbook.FollowHyperlink Address:= _
    "http://finance.yahoo.com/q?s=" & Target.Value
  4. Glad to help

    Glad to help
  5. I don't think you understood at all. See...

    I don't think you understood at all. See attached for what I am talking about.

    42771
  6. Replies
    12
    Views
    294

    You can unprotect all cells on the sheet>protect...

    You can unprotect all cells on the sheet>protect the cells desired with a password>give the pw to those desired. You must then assume that all attended Texas A & M because sheet protection is very...
  7. You could have a separate sheet and just use the...

    You could have a separate sheet and just use the data (with or without copying the data) from the desired sheet. Or, on the separate sheet, select the sheet and have a macro put the graphs on that...
  8. You only provide ONE sheet. However, You need NOT...

    You only provide ONE sheet. However, You need NOT do in each sheet when you can simply use ONE graph and indicate which sheet to graph. What is this for?
  9. Replies
    30
    Views
    1,475

    Zeddy, Yes, but when I clicked the address label...

    Zeddy,
    Yes, but when I clicked the address label I do get a better option but after selection it doesn't go away.
    Did you use the omni print option. I should have had caveat about sheet name or...
  10. As Maud said, sumif should do the job for simpler...

    As Maud said, sumif should do the job for simpler ones and is less resource intensive.
  11. Replies
    30
    Views
    1,475

    Very NICE indeed. Small suggestion(s).Make all...

    Very NICE indeed. Small suggestion(s).Make all shapes NOT print. Put this in the ThisWorkbook module and simply use excel print options or assingn little printer icon to Activesheet.printpreview and...
  12. Replies
    30
    Views
    1,475

    Could it be that you are selecting data that does...

    Could it be that you are selecting data that does NOT exist? On the sample data only goes to end of Jan. No March.
    Also, suggest consistency in design of where header row is for efficiency in...
  13. Replies
    2
    Views
    61

    All of that should be doable but may I suggest...

    All of that should be doable but may I suggest using FINDNEXT instead to find each instance and prompt you to correct. Attach file with complete explanation,
  14. Replies
    17
    Views
    438

    One possible way to solve this problem would be...

    One possible way to solve this problem would be to use INDIRECT
    =F208/2+INDIRECT("D5")
    or something similar
  15. =SUM(INDIRECT("I2:i"&K1))

    =SUM(INDIRECT("I2:i"&K1))
  16. Replies
    17
    Views
    438

    You aren't too clear about the criteria but this...

    You aren't too clear about the criteria but this should do as you like.


    Option Explicit
    Sub fixformulas()
    Dim sh As Worksheet
    Dim f As Range
    Dim mf As String
    For Each sh In Worksheets
    If...
  17. Put this code in the sheet module. See 42702...

    Put this code in the sheet module. See 42702
    Option Explicit

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim mv As String 'Range
    If Target.Address <> Range("f1").Address Then Exit...
  18. https://www.google.com/?gws_rd=ssl#q=excel+data+to...

    https://www.google.com/?gws_rd=ssl#q=excel+data+to+outlook+calendar
  19. [SOLVED] attach file with code properly presented.

    attach file with code properly presented.
  20. Replies
    5
    Views
    240

    42684 Here is a set of macros and different...

    42684 Here is a set of macros and different formulas for your ORIGINAL request. You adapt.

    Option Explicit
    Sub CopySheet()
    Sheets("Template").Copy After:=Sheets(Sheets.Count)
    ActiveSheet.Name...
  21. Replies
    2
    Views
    130

    [SOLVED] 'simplest to understand for i=3 to sheets.count...

    'simplest to understand
    for i=3 to sheets.count
    sheet(i).activate
    lastrow = Cells(Rows.Count, 1).End(xlUp).Row
    Range("A1").AutoFilter
    Range("$A$1:$L$" & lastrow).AutoFilter Field:=3,...
  22. No mention in OP post, so I guess OP will have to...

    No mention in OP post, so I guess OP will have to tell us what is desired.....
  23. May I suggest a simpler method. Copy Month1...

    May I suggest a simpler method.
    Copy Month1 after month1>rename month2>fill in the new items>sort if desired.

    Also, if col b items are recurring then have a macro using FINDNEXT or index/match...
  24. Replies
    9
    Views
    439

    [SOLVED] While all of that may be appropriate, I still...

    While all of that may be appropriate, I still subscribe to the KISS principle and think this should work for most, if not all where the 1st column is the key. Why MOVE the data? Simply select 1st row...
  25. Replies
    9
    Views
    439

    [SOLVED] Am I missing something. Wouldn't it be simpler to...

    Am I missing something. Wouldn't it be simpler to just sort and use data>subtotals
Results 1 to 25 of 241
Page 1 of 10 1 2 3 4