Multiple files to 1 'master' file - best process??
I have a department of around 20 ppl, each have excel fies that can contain upto 10 tabs with those in turn possibly containing upto 500 lines each.
I now need to take totals from each person, linking it back to my one 'master' file.
Now i could do this with various VLookups but speed would be an issue here. I will be working off company servers too, so shared drives are invloved.
Does anyone have any ideas on the best way this should be done?
Re: Multiple files to 1 'master' file - best process??
I recently posted a similar solution. This will allow you to select a folder that contains other files, then it will copy data from a certain sheet name.
maybe you can adapt it.
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By RoarMax in forum Excel Programming / VBA / Macros
Last Post: 04-03-2013, 06:30 AM
By dspraveen_23 in forum Excel Programming / VBA / Macros
Last Post: 12-08-2012, 12:59 PM
By jelena1290 in forum Excel Formulas & Functions
Last Post: 11-10-2012, 12:36 AM
By Alley oop in forum Excel Programming / VBA / Macros
Last Post: 09-19-2012, 04:29 PM
By Delta223 in forum Excel General
Last Post: 01-30-2010, 02:49 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1