Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
Functions across multiple worksheets | Excel Worksheet Functions | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |