+ Reply to Thread
Results 1 to 2 of 2

Consolidation of large number of files

  1. #1
    Registered User
    Join Date
    London, England
    MS-Off Ver
    Excel 2003

    Consolidation of large number of files

    Hi. Was wondering if anyone knew if there was an easier way to consolidate a large number of spreadsheets into one without doing a load of vlookups (due to them being large sheets and other people colleges adding new lines)?

    For example are there any macros that can pick up a load of data from the other spreadsheets and past them into my consolidated spreadsheet without any hassle. Then perhaps have formulas to pick up the data from the consolidated workbook.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010

    Re: Consolidation of large number of files

    If the layout of the workbooks is the same, i.e. same columns, sheet names etc then a macro would be quite straightforward. This sort of thing is asked almost daily if you do a search of the forum. If you still need help post back.

    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1