Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.05 seconds.

  1. Thanks for the useful link, much appreciated

    Thanks for the useful link, much appreciated
  2. Macro to copy data from one folder to another

    I have a workbook that contains a macro to copy files from one folder to another. I would like the code amended so that if the file in the destination folder already exits, it must not overwrite the...
  3. Replies
    5
    Views
    143

    Thanks for the help chaps

    Thanks for the help chaps
  4. Replies
    5
    Views
    143

    Set Default Folder when opening Files

    I am using Windows 8 and Office 2013

    I would like to know how to set a default folder when opening up files using Office 2013
  5. Replies
    3
    Views
    137

    Thanks for the advice

    Thanks for the advice
  6. Replies
    3
    Views
    137

    Managed to sort out my macro by breaking it down...

    Managed to sort out my macro by breaking it down into two sections


    Sub Print_Income_Statement()
    Sheets("Income Statement").Select

    Dim LastRow As Long
    LastRow = Sheets("Income...
  7. Replies
    3
    Views
    137

    Print Macro with seperate headers

    I have a macro to print a worksheet.

    When printing I want "revenue" Cell A2 to print in the header from A3 to A27 and "Costs" A28 to print in he header thereafter

    See Attached file containing...
  8. Thanks for the help , much appreciated

    Thanks for the help , much appreciated
  9. Replies
    1
    Views
    83

    [SOLVED] Just to let you know that I resolved the problem...

    Just to let you know that I resolved the problem

    A28 =SUM(SUMIFS(J:J,K:K,A28),(L:L,B28))
  10. Replies
    1
    Views
    83

    [SOLVED] Formula Problem

    I have tried to set up formula to add various categories in Cols K & L based on values in Col J and criteria in A28 onwards. I am using Excel 2010

    It would be appreciated if someone could assist
  11. Formula to add Data

    I would like to set up a formula to give add the totals in Col J, for the following categories

    Expense Input
    Internal Internal
    Output Sales


    See Sample Data attached
  12. Thanks for the help. Will be careful with...

    Thanks for the help. Will be careful with explanations
  13. Copying specific account numers and values

    I have account numbers and values in Cols A & B respectively on sheet Data

    I would like to extract all the account numbers one row above 125915 and its value in Col B to Sheet "Input Vat" and all...
  14. Replies
    8
    Views
    185

    Thanks for the help. Code works perfect

    Thanks for the help. Code works perfect
  15. Replies
    8
    Views
    185

    Thanks for the help. We are close to resolving...

    Thanks for the help. We are close to resolving the problem

    I have attached three files

    1) Extract Files Raw Data
    2) Extract files Manual Extraction -this is what the file should look like...
  16. Replies
    8
    Views
    185

    Thanks for the reply. I am using Excel 2010. Your...

    Thanks for the reply. I am using Excel 2010. Your guess is 100% spot on.

    I have managed to resolve the other problem. Thanks for enquiring
  17. Replies
    8
    Views
    185

    Extracting unique numbers

    I have a spreadsheet that contains account number in Col A with corresdponding numbers in Col B. Some of the account numbers in Col A may appear several times, but the numbers in Col B are unique.
    ...
  18. Thanks for the reply, Never made mention of the...

    Thanks for the reply, Never made mention of the version. I'm using Office 2010
  19. Thanks for the help. It now comes up with error...

    Thanks for the help. It now comes up with error code 445, object does not support this action

    The folowing code is highlighted


    With Application.FileSearch
  20. Thanks for the help My apologies. I had to...

    Thanks for the help

    My apologies. I had to leave in a hurry to go to a function and uploaded the workbook not realising at the time that the workbook Macros were password protected. I have now...
  21. Thanks for the reply. I agree that it is...

    Thanks for the reply.

    I agree that it is easier to have a macro open up the files one by one. Once the file is open the data needs to be refreshed (See Refresh button) and updated with the...
  22. I want to open all workbooks in c:\pull and well...

    I want to open all workbooks in c:\pull and well and its the sub-folders where its contains in the name "ACCNTS (P)" for eg BR1 ACCNTS (P) using a macro

    I will then update these one at a time
  23. Thanks for the reply. I am looking to open up all...

    Thanks for the reply. I am looking to open up all files in c:\pull and its sub-foldfers for eg c:\pull\tbbr1 where there are files that contain the name accnts (p)
  24. Hi Guys Thanks for the info- most appreciated

    Hi Guys

    Thanks for the info- most appreciated
  25. Thread: Library

    by HowardC
    Replies
    1
    Views
    97

    Library

    Is there a way to increase the number files in the Library (using Windows 7) for easy access?. I have tried to include a folder but the system wont allow any more files to appear in the library
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4