Consolidating time sheets

**Johny1** · 02-26-2009, 08:08 PM

Hi All

I receive more than 75 time sheet like the one attached every week.
Is there a siple way to consolidate them in one workbook at a shared folder each week?

Many thanks

Johny

**Leith Ross** · 02-26-2009, 08:15 PM

Hello Johny1,

The workbooks are setup to emailed. Are you receiving the emailed workbooks and want to copy all the sheets into a single "master" workbook?

**Johny1** · 02-27-2009, 05:50 PM

Hello Leith

Some people email the sheet, others bring a printed copy. I am looking for an easy way to collate time sheets in one sheet without receiving all those emails.

Regards

**Johny1** · 06-13-2009, 08:59 AM

Hi All

Still searching for an answer to the querry below. Is there an easier way to collate these timesheets in one workbook?

Many thanks.

**royUK** · 06-13-2009, 09:07 AM

You could create a macro to copy the timesheets tothe specified folder on the server, i've used this method successfully before.

**Johny1** · 06-13-2009, 09:19 AM

Hi Roy

Thanks for your quick reply.

Could you help me with creating this macro?

Many thanks

**royUK** · 06-13-2009, 09:43 AM

You need a master workbook on the server to receive the sheets, each sheet should be named for the user. Then start by recording a macro to copy the sheet to the master workbook

http://www.excel-it.com/record_macro.htm