Search:

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

Page 1 of 11 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    1
    Views
    124

    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...
  2. 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...
  3. 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...
  4. Replies
    2
    Views
    125

    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...
  5. 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...
  6. 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
    ...
  7. Replies
    3
    Views
    180

    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...
  8. Replies
    1
    Views
    147

    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...
  9. 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...
  10. 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
  11. Replies
    1
    Views
    580

    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...
  12. 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...
  13. Replies
    15
    Views
    924

    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...
  14. [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 $...
  15. Replies
    15
    Views
    924

    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...
  16. [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...
  17. Without VBA here is a possible solution: ...

    Without VBA here is a possible solution:
    First I think you should focus your attention on Sheet2 since it has only 30 rows.
    Make a copy of sheet2 worksheet and give it a name like...
  18. [SOLVED] Below is what I think you are looking...

    Below is what I think you are looking for.

    Prior to running the macro "MyCopy"


    1 You will need to have open 3 Excel files with one...
  19. Replies
    10
    Views
    4,427

    Dear 6rtury: Below is the article from the...

    Dear 6rtury:

    Below is the article from the "askwoody" home page. Have you tried the last suggestion?

    In other words, can you remove the update KB3008923?

    If not I would suggest you Google...
  20. Summersond: Can you provide a bit more...

    Summersond:
    Can you provide a bit more information. How does the user provide the original data? Is it by an Excel Input Box? is it by entering the information in a specific cell of a Workbook?...
  21. Thread: US to UK dates

    by duthiet
    Replies
    3
    Views
    295

    bobski Not sure what you mean by custom? If the...

    bobski
    Not sure what you mean by custom? If the date is entered as text by example 09/26/2014 for September 26, 2014
    Use the funciton datevalue() which will turn the text back to a serial number....
  22. LL: Try using CurrentRegion combined with...

    LL:

    Try using CurrentRegion combined with selecting visible cells only and then paste.
    Something like the below

    'Filter Sheets and copy rows to MKT
    Worksheets(i).Range("B7:L7").AutoFilter...
  23. Replies
    9
    Views
    956

    Dear Yangyang Welcome to the lounge. ...

    Dear Yangyang

    Welcome to the lounge.

    Everyone want to help and I know excel can do this, but the data provided is very difficult to understand. What is "Summarization Record"? These entires...
  24. Replies
    2
    Views
    339

    Could a Pivot Table give the information you...

    Could a Pivot Table give the information you want?

    First highlight all data then on Ribbon create a Pivot table. Drag and Drop "Table" as rows and "Fields" as columns. Then place Fields as value...
  25. Replies
    5
    Views
    832

    Fred: Your post does not mention if anyone...

    Fred:

    Your post does not mention if anyone attempted a simple test. In other words, did anyone create a new Apple Excel Workbook and insert a checkbox control? Then upload to cloud and test on...
Results 1 to 25 of 251
Page 1 of 11 1 2 3 4