Bringing data from mulitple worksheets to a master sheet

**kgkev** · 06-10-2008, 06:58 AM

Each salesman has an enquiry log / hot prospect sheet that they are responsible for.

At present at the end of the month our receptionist has to consolidate this information manually onto a master sheet.

I would like to create an automatic master sheet that auto updates each time it is opened.

It has to read data from about 13 work books each with varting amounts of date. All works books are formatted identically (or they will be)

I would like the date to be sorted by date.

**royUK** · 06-10-2008, 08:48 AM

Will the workbooks be in one Directory?

Attach an example of the workbook to copy.

**kgkev** · 06-10-2008, 09:13 AM

All the files will be stored in the same directory on our server.

I am unable to attach the spread sheet - I keep getting an error (I have tried .xls & .zip)

Basicaly row 1 is a header
2 down will contain consistent data

Coloumns A-Q are filled -

Status, order date, customer, country, area, sales man, machine, quote price, etc.

It is just data - Each spreadsheet will have no forumla just manually typed info.

If you still need an example can you suggest a free file sharing website I can use?

**royUK** · 06-10-2008, 09:18 AM

You won't need to copy the header row, but what about the "consistent data"?

**kgkev** · 06-10-2008, 09:42 AM

Yeah don't need the header

By consistent - I mean there will be no blank lines. until the end of the data.

**royUK** · 06-10-2008, 09:54 AM

You'll have to test this. The code first asks the user to select a Folder containing the files. Then copies the data from each workbook to the one containing the code.