Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. I have attached a workbook which I tried to adapt...

    I have attached a workbook which I tried to adapt from a Workbook Zeddy assisted me a few months to move files from a directory and sub-directories to another folder

    I now want to open all XLS...
  2. Macro to open up specified Files in Directory and Sub-directory

    I have several files in directory c:\pull as well as several sub-folders in this directory starting with TB for eg TBBR1, TBBr2 etc

    What I want to do is to open up all the XLS files that contains...
  3. Hi Steve Thanks-this works perfectly Howard

    Hi Steve

    Thanks-this works perfectly

    Howard
  4. Have Steve Have done so, but still don't get...

    Have Steve Have done so, but still don't get correct solution

    See attached file with my Formula in B2, where I am trying to compute the values greater than 60 days where the values are > 0 and...
  5. Hi Steve I have a similar Calculation on a...

    Hi Steve

    I have a similar Calculation on a Pivot Table, but now need to calculate the ageing 60-90, 90-120 , > 120

    It would be appreciated if you could assist me
  6. Hi RG Not sure what to do-have seen your...

    Hi RG

    Not sure what to do-have seen your link.

    Have you had a look at my screen shot "run time error 1004-cannot run the macro 'Auto_update!'

    It is only the code below that is causing the...
  7. Opening up all files in folder and then running Macro in opened workbooks

    I have a macro that opens up several files in one folder and then select the macro Auto_Update () in each of these workbooks

    However, I get a run time error 1004 and the following code is...
  8. Replies
    8
    Views
    158

    Hi Andrew Just to let you know that I have...

    Hi Andrew

    Just to let you know that I have resolved the problem, buy approaching it is small steps

    Once again thanks for pointing me in the right direction. It took me a while, but I am almost...
  9. Replies
    8
    Views
    158

    Hi Andrew I will try to make this a simple as...

    Hi Andrew

    I will try to make this a simple as possible

    Each month I export files from our mainframe to a directory C:\extract. These files are automatically set to save as CSV files when...
  10. Replies
    8
    Views
    158

    hi Andrew Thanks for the your input. I have...

    hi Andrew

    Thanks for the your input. I have noted your comments and will have one more attempt and clarifying what I am attempting to do
  11. Thanks very much for the explanation Howard

    Thanks very much for the explanation

    Howard
  12. Hi Steve This is a brilliant formula. Please...

    Hi Steve

    This is a brilliant formula. Please explain to me how this works, I am familiar with sumif and offset, but do not understand this formula which give me the correct result

    Howard
  13. Hi Steve See example of Pivot Table attached...

    Hi Steve

    See example of Pivot Table attached with Formula on Pivot Sheet

    It would be appreciated if you would amend the formula to accomate a change in the number of columns

    I would like to...
  14. Hi Steve The data attached was sample data...

    Hi Steve

    The data attached was sample data from the Pivot Table. I have named the Grand Total in the final column and have got this formula to work


    =IF(ISBLANK(A4),"",IF(A4="Grand...
  15. Formula to calculate values > 0 on row 5 on Pivot Table

    I am using the following formula on Pivot table Row 5 where the items are 60 days & over
    and the value > 0

    =SUMIF(B7:FV7,">0",B7:FV7)

    However if the data changes there will be more or less...
  16. Replies
    8
    Views
    158

    Hi Andrew Have you had a chance to have a look...

    Hi Andrew

    Have you had a chance to have a look at my problem ?
  17. Replies
    2
    Views
    64

    Thanks for your input

    Thanks for your input
  18. Replies
    2
    Views
    64

    Rounding Difference CsV File

    I have a Trial Balance which I export as a CSV

    When totalling up in screen there is a small rounding difference of 0.00000004 (total of Trial Balance) (this is of no significance

    However when...
  19. Replies
    2
    Views
    86

    Thanks for the help, Steve. Will test & let you...

    Thanks for the help, Steve. Will test & let you know
  20. Replies
    2
    Views
    86

    Vlookup with Offset

    I have the same text in Col B after 'TOTAL ADJUSTED GROSS PROFIT" and after "TOTAL NET (PROFIT)/LOSS"

    The values are in Col F

    I would like to look up the values for Dept1 , Dept2 etc but these...
  21. Replies
    8
    Views
    158

    Hi Andrew Currently I use the macro Sub...

    Hi Andrew

    Currently I use the macro Sub Update_workbooks in a separate workbook to allow the user to select one of the files in the directory C:/Parts & SVC Sales for eg Br1 Service Sales that...
  22. Replies
    8
    Views
    158

    Macro to open up file and update files

    Macro to open and update several workbooks



    I have the following code which is used to open up workbooks one by one and to update these . The source workbooks in CSV format are in the folder...
  23. Replies
    7
    Views
    177

    Hi Maud I was indeed battling. Will go through...

    Hi Maud

    I was indeed battling. Will go through your code so I fully understand the logic

    Thanks for the help, code works perfectly

    Howard
  24. Replies
    7
    Views
    177

    Hi RG Thanks for the help Have tried to...

    Hi RG

    Thanks for the help

    Have tried to amend my code by incorporating your suggestions, but still cannot get it to work



    Sub SendFiles()
    Dim vFilename As Variant
  25. Replies
    7
    Views
    177

    Hi RG I am trying extract the sheet "Man...

    Hi RG

    I am trying extract the sheet "Man accounts Bank" save this as Man Accounts Bank" and attach to email and send

    I am having problems with this section of the code

    I get wrong number of...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4