Search:

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

Page 1 of 11 1 2 3 4

Search: Search took 0.01 seconds.

  1. Dear Bhushanvshah: Does the attached help? It...

    Dear Bhushanvshah:

    Does the attached help? It uses 3 pivot tables to show results. By Clicking the Text Box "Update Tables" it will refresh all three pivot tables and give the results in your...
  2. Dear Bhushanvshah: Attached is a solution. It...

    Dear Bhushanvshah:

    Attached is a solution. It uses a new formula in Col L and then advanced Data Filter.

    Each time you populate the sheet you will need to go to the "Data Ribbon" and select...
  3. Replies
    3
    Views
    167

    Dear MNN: Does the below help. These notes...

    Dear MNN:

    Does the below help. These notes were made when I put together dependent drop down.

    Create Multiple Drop Down Lists Based On Prior Selection

    The real Trick to getting this to...
  4. Replies
    10
    Views
    397

    Zeddy: Yes Totally Awesome!!! I have never...

    Zeddy:

    Yes Totally Awesome!!!

    I have never used CountIf and not only did you use CountIf you put it on Steroids.
    Great Solution.

    DuthieT
  5. Replies
    10
    Views
    397

    Ankitag85: Attached is a formula based...

    Ankitag85:

    Attached is a formula based solution, no Maco needed.

    I did insert two rows in the data sheet and put the formulas on the data sheet.

    If you don't want to touch the data sheet...
  6. Replies
    3
    Views
    206

    Dear anasali94 I woud suggest using formulas...

    Dear anasali94

    I woud suggest using formulas rather than VBA.

    Whether you use VBA or just formulas the key is to make sure there is a unique ID for Each Record so Excel can compare the lists.
    ...
  7. Replies
    5
    Views
    425

    Dear Ric: Welcome to the lounge. Perhaps the...

    Dear Ric:

    Welcome to the lounge. Perhaps the following article can assist. In effect, you have excel find the Maximum, set this as its own chart value and make it part of the chart as a "point"...
  8. Replies
    1
    Views
    132

    Dear Carmine: Something like this Sub...

    Dear Carmine:

    Something like this


    Sub TestIt()
    Application.EnableEvents = False
    yyy = ActiveSheet.Range("C10").Value 'for this example ActiveSheet C10 has Folder Path
    For Each sht In...
  9. Replies
    1
    Views
    128

    Dear Antmart2 Welcome to the Lounge Attached...

    Dear Antmart2
    Welcome to the Lounge

    Attached please find a revised version of you Matrix Lite workbook.

    I was not 100% certain what you were looking for concerning your "Ideal" solution so...
  10. Replies
    1
    Views
    172

    Welcome to the Lounge. I have attached a...

    Welcome to the Lounge.

    I have attached a possible solution that does not use a macro. This method should be more flexible than a macro approach especially if you keep adding new Worksheets. Just...
  11. I found this out on the Web perhaps this could...

    I found this out on the Web perhaps this could solve the issue.

    What I had to do was recreate the profile on the computer and also recreate a new roaming profile from the
    server. This solved the...
  12. One thought, when the User opens the spreadsheet...

    One thought, when the User opens the spreadsheet does his Excel also load add-ins? This can cause issues.
    Try to load Excel with no add-ins and see if they can now edit.

    Alternative when the...
  13. Replies
    2
    Views
    195

    Quick suggestion. Open Excel on File Ribbon...

    Quick suggestion. Open Excel on File Ribbon Select New Template. I went to "Monthly" and found may usable calendars. Find the one you want and download it to your local drive in the Templates...
  14. Happy New Year to you. You did not say which...

    Happy New Year to you.

    You did not say which Excel your running so I hope its 10 or above.

    After looking at the problem my recommendation is to abandon all the complex formulas. Instead use...
  15. See the attached. Should work as long as the...

    See the attached.

    Should work as long as the unneeded rows are blank or have the same words as the examples.

    You can copy down the formulas to as may rows as you desire and tweak as needed
    ...
  16. Replies
    3
    Views
    262

    No Macro Suggestion What I would suggest is...

    No Macro Suggestion

    What I would suggest is using Excel "Custom Views" This handy little item allows you to present not only the way a report is viewed on screen but also remembers all the...
  17. Replies
    1
    Views
    211

    Dear zmagic: Rather than a Macro see the...

    Dear zmagic:

    Rather than a Macro see the attached. This would have been a bit easier if the text showed the commas in the proper places for the totals. To get around this you will need to use...
  18. Genej313: A better way to tackle this project...

    Genej313:

    A better way to tackle this project may be to segregate you links to be in their own area.

    So in the Summary Workbook, you should put in a place below and to the right of the Summary...
  19. I just had a similar problem with my Personal...

    I just had a similar problem with my Personal template. I found this tip on the Web and it worked for my problem. try saving the book as an xlsa.

    Hope it works for you

    TD
  20. Replies
    1
    Views
    659

    Dear Dansparks81 Welcome to the Lounge. ...

    Dear Dansparks81

    Welcome to the Lounge.

    Attached is an Excel File with a Macro that should do what you wanted.

    Please note the Macro needs the following or it will not work.

    The path name...
  21. Perhaps the below can link can provide assistanc...

    Perhaps the below can link can provide assistanc

    http://www.jpsoftwaretech.com/using-excel-vba-to-set-up-task-reminders-in-outlook/
    Also from the site
    About JP
    I'm just an average guy who...
  22. Replies
    15
    Views
    1,070

    Steve: Yes you can link. For closed files you...

    Steve:

    Yes you can link. For closed files you will need the full path name. Since you already have the full path names all you need is to use Excel's HYPERLINK Function.

    Example:

    Cell A1...
  23. [SOLVED] I think this is what you are looking for. It...

    I think this is what you are looking for.

    It creates a table from your data and then uses COUNTIF and SUMIF to get needed information

    Was not sure if you wanted number of trades each month or $...
  24. Replies
    15
    Views
    1,070

    Steve: Welcome to the lounge. The good news is...

    Steve:
    Welcome to the lounge. The good news is Excel should be able to assit you. If the files remain under say 10,000 Excel has most of the tools you will need. With Excel Open select "Data" to...
  25. [SOLVED] What I provided should work. I ran the macro...

    What I provided should work.

    I ran the macro and got the same results as in your Output 1; Output 2; and Output 3
    Attached are MyData01.xlsx [data file one]
    MyData02.xlsx...
Results 1 to 25 of 260
Page 1 of 11 1 2 3 4