Merging Spreadsheets to one Master

**KLahvic** · 06-15-2009, 11:28 AM

I have a user form system that when used populates information into a spreadsheet. This system is being sent out to over 100 people to use and they will email the spreadsheet that they create back to me completed. What I would like to do is somehow compile all of this data into one master spreadsheet. The information on all different files will be the same as far as headers and so forth but entries will have different information on them. Is there a way to do this with a Macro and a command button to search for the files and to pull the data into one sheet?

Thank you in advance, I have searched the forum for some help on this matter but cant seem to find any.

**ravishankar** · 06-16-2009, 07:11 AM

Hi
It is possible.The macro codes need to be tailored to your specific case depending on the layout of your source workbooks and how you want it compiled in the master workbook. Can you give us more details
Ravi

**KLahvic** · 06-16-2009, 08:43 AM

Ravi -

Thank you for the response. I have workbooks containing one worksheet each, these are the sources. They have data from columns A through Y with a header on row 1. There may be several entries (rows) of information but probably not more than 250 entries per sheet. I will be receiving one of these from each of my 100 distributors which I would like to merge them all onto one sheet with the same header and all of the same information in the same order.

If there is any more information that you require to help me, I would greatly appreciate it.

I also made another post, probably against the rules I am not sure, but I had code that I tried to configure to my needs but to no avail. I do not know the link to it, but I will edit this post when I find it.

Ken