Merge / Consolidate Worksheets

Each day I receive completed worksheets (About 25 a day) in the shape of an Excel document.

I am looking for a way to create one master file (Possibly Sorted By Date) that consolidates all the info from one tab on the completed spreadsheet into - obviously - a master file - Data list.

The spreadsheets as they come in have about 8 tabs, they are then stored in seperate folders on the same branch using the employees name.

As they come in daily, I am hoping to open the master and have a macro (??) that updates by appending all the most recent data.

Originally Posted by Hoopsah

Each day I receive completed worksheets (About 25 a day) in the shape of an Excel document.

I am looking for a way to create one master file (Possibly Sorted By Date) that consolidates all the info from one tab on the completed spreadsheet into - obviously - a master file - Data list.

The spreadsheets as they come in have about 8 tabs, they are then stored in seperate folders on the same branch using the employees name.

As they come in daily, I am hoping to open the master and have a macro (??) that updates by appending all the most recent data.

Hi,

David McRitchie has a page on gathering data from other worksheets, whether by Formula or by Macro.

hth
---

Cheerys Bryan,

Not really what I am looking for but a good site none the less,

Cheers

G

Originally Posted by Hoopsah

Cheerys Bryan,

Not really what I am looking for but a good site none the less,

Cheers

G

As the site covered 'Building a Table of Contents', 'Looping through a set of workbooks listed in a range', 'Looping through a list of sheets', finding the First and Last cell in a column, etc it was hoped that it would be useful to you.

Perhaps an explanation of the type of help that you are looking for, ie, Formula, Code, or Quote etc. might help.

---

Hi Bryan,

had another look at the site and there is possibly a section that I can use.

I'm sorry, but part of the problem is that so far I have only received one sheet back from the employees so it is hard to start building this. I was just trying to keep a step ahead.

Basically, I will receive the same template back from 20 employees and I want to merge them all together on a daily basis, thus allowing me to start extracting information from them.