Search:

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

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. 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
  2. Replies
    1
    Views
    358

    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...
  3. 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...
  4. Replies
    15
    Views
    709

    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...
  5. [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 $...
  6. Replies
    15
    Views
    709

    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...
  7. [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...
  8. 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...
  9. [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...
  10. Replies
    10
    Views
    3,461

    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...
  11. 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?...
  12. Thread: US to UK dates

    by duthiet
    Replies
    3
    Views
    258

    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....
  13. 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...
  14. Replies
    9
    Views
    682

    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...
  15. Replies
    2
    Views
    300

    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...
  16. Replies
    5
    Views
    552

    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...
  17. Thread: Copy & Paste

    by duthiet
    Replies
    4
    Views
    263

    A problem I have run into is "pasting" where the...

    A problem I have run into is "pasting" where the Crtl C does pick up the data but Excel will not allow the data to be pasted. If this is the issue it may have something to do with Add Ins. However,...
  18. Replies
    6
    Views
    1,756

    Sorting data for futher analysis

    Ed

    Attached is a sample of what I think you are looking for.

    However, it may be better to Pivot Table the Data and use the Pivot Table Filters to extract the desired results. By example use...
  19. Replies
    2
    Views
    792

    Have not seen this specific problem but make sure...

    Have not seen this specific problem but make sure the Workbook is 'compatible' with Exel 2013. This may require that the Workbook be saved using a different extension. Also in Excel 2010 certain...
  20. Replies
    8
    Views
    1,155

    Your Idea is very good but needs some refinement....

    Your Idea is very good but needs some refinement.

    Since auto-complete needs all of the informaiton to be in one column you may try this:

    At top put in one column all 25 Categoires. Next hide as...
  21. Replies
    8
    Views
    1,155

    Welcome to the Lounge. Just a suggestion. Skip...

    Welcome to the Lounge.

    Just a suggestion. Skip the Combo Box and Instead Use Auto-complete.
    If possible make each of the 25 items unique, by example:
    Original List
    Machine Repair
    Machine...
  22. Replies
    4
    Views
    820

    Zeddy: You might try...

    Zeddy:

    You might try http://www.mztools.com/v3/download.aspx, I found this on the Web but have never used the tool

    Good Luck

    Tom D
  23. Muddy: Can you be a bit more specific. For...

    Muddy:

    Can you be a bit more specific. For Excel to assist you would need to open the workbook every day so that the workbook would compare the due date and the current date. This could be done...
  24. D: One thing that may help, before running the...

    D:

    One thing that may help, before running the Macro set Excel 2007 Security to the lowest level. Then run your Macro.
    After the Macro is done put the security back to the level your IT Group has...
  25. Replies
    12
    Views
    2,055

    For learning VBA you might want to check hte...

    For learning VBA you might want to check hte below MS site

    http://msdn.microsoft.com/en-us/library/ee814737%28v=office.14%29.aspx

    Hope this helps.

    TD
Results 1 to 25 of 242
Page 1 of 10 1 2 3 4