how can I combine multiple worksheets into one?
 

I created a client billing timesheet for my employer. Now he wants to have
all the timesheets for each associate (30) drop into one database that we can
sort and obtain information from. I'm sure I can do this on a weekly manual
basis. Is there any way to have these linked to a common spreadsheet/database
that will update with each person's daily entries?

Hi Deb

You can run this macro every week
http://www.rondebruin.nl/copy2.htm

Or for a few cells create links
http://www.rondebruin.nl/summary.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Deb Bagby" <Deb wrote in message ...
I created a client billing timesheet for my employer. Now he wants to have
all the timesheets for each associate (30) drop into one database that we can
sort and obtain information from. I'm sure I can do this on a weekly manual
basis. Is there any way to have these linked to a common spreadsheet/database
that will update with each person's daily entries?