Search:

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

Page 1 of 11 1 2 3 4

Search: Search took 0.01 seconds.

  1. Try this ARRAY entered formla if all grades are...

    Try this ARRAY entered formla if all grades are in CAPS

    =IF(COUNTA(B3:G3)<6,"more grades",CHAR(INT(SUM(IF(B3:G3<>"",CODE(B3:G3))/COUNTA(B3:G3)))))
  2. Replies
    16
    Views
    306

    do you want to copy to the sub sheet (located...

    do you want to copy to the sub sheet (located where????? sub folder...... Not at all clear here)
  3. =w15/if(u15="",800,900)*100

    =w15/if(u15="",800,900)*100
  4. I am sick and can't work on this but here is...

    I am sick and can't work on this but here is the basic idea then use autofilter

    Month adavisor Military Member Military Spouse Civilian or Dependent Total
  5. Replies
    27
    Views
    1,089

    [SOLVED] If we are to assume that all files are xl or the...

    If we are to assume that all files are xl or the user know what excel file he wants, the filters are not necessary and my 2 liner works just fine.

    Sub SelectFileGetAllSheetsSAS1()
    Workbooks.Open...
  6. My suggestion is to have ONE file with 5 tabs...

    My suggestion is to have ONE file with 5 tabs with all dates on one tab where you can filter for the months. Then just use sumproduct on the master sheet.
    Or, ONE file with ONE tab and all data and...
  7. Replies
    27
    Views
    1,089

    [SOLVED] Zeddy, Thanks for the kind words. And, unless I...

    Zeddy, Thanks for the kind words. And, unless I forget (can be forgiven at my age), I always use dims. My last post doesn't call for one. Option explicit at the top of my module (which I normally...
  8. Replies
    27
    Views
    1,089

    [SOLVED] You want simple. I'll give you simple.... Sub...

    You want simple. I'll give you simple....

    Sub SelectFileGetAllSheetsSAS1()
    Workbooks.Open Filename:= _
    Application.GetOpenFilename(Title:="Select File")
    Sheets.Copy...
  9. Replies
    27
    Views
    1,089

    [SOLVED] Us old folks ( I had my 79th birthday on income...

    Us old folks ( I had my 79th birthday on income tax day) learn something new every day.
  10. Replies
    27
    Views
    1,089

    [SOLVED] Based on the original post, why not simply ...

    Based on the original post, why not simply

    Sub SelectFileGetAllSheetsSAS()
    Dim ds As String
    Dim fNameAndPath As Variant
    ds = ThisWorkbook.Name
    fNameAndPath =...
  11. Replies
    23
    Views
    1,062

    42904 You may like this as well or...

    42904 You may like this as well or better. See Attached



    Option Explicit
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Cells.FormatConditions.Delete
    If...
  12. [SOLVED] You may also like this CHOOSE formula for col A...

    You may also like this CHOOSE formula for col A
    '=CHOOSE(WEEKDAY(C3),"error","error","mm","Pb","error","mm","pb")
    and chg the CF to reflect =<today()
  13. Replies
    16
    Views
    697

    [SOLVED] 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.
  14. Replies
    16
    Views
    697

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

    Why dummy sheets??

    =SUM(WK1:WK13,D4)
  15. Replies
    9
    Views
    438

    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
  16. Glad to help

    Glad to help
  17. 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
  18. Replies
    12
    Views
    803

    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...
  19. 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...
  20. 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?
  21. Replies
    30
    Views
    1,889

    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...
  22. 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.
  23. Replies
    30
    Views
    1,889

    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...
  24. Replies
    30
    Views
    1,889

    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...
  25. Replies
    2
    Views
    84

    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,
Results 1 to 25 of 253
Page 1 of 11 1 2 3 4