Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Multiple Worksheets and Cells
I have to process up to 125 worksheets with similar information every week
and then combine it into a master order form. The data I am compiling is very basic, names, addresses, cost centers, etc. However, I cannot figure out which formula to use to be able to gather these individual worksheets from individual users and populate different rows, without overwriting the info, on the master worksheet. Please help, I need to save hours of time!?!?!? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Multiple Worksheets and Cells
Hi Lkap
This is a code example http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Lkap" wrote in message ... I have to process up to 125 worksheets with similar information every week and then combine it into a master order form. The data I am compiling is very basic, names, addresses, cost centers, etc. However, I cannot figure out which formula to use to be able to gather these individual worksheets from individual users and populate different rows, without overwriting the info, on the master worksheet. Please help, I need to save hours of time!?!?!? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking from multiple worksheets | New Users to Excel | |||
Linking multiple worksheets | Excel Worksheet Functions | |||
linking multiple columns onto multiple worksheets | Excel Discussion (Misc queries) | |||
Linking multiple worksheets | Excel Worksheet Functions | |||
Linking and formatting multiple worksheets | Excel Worksheet Functions |