Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Worksheets
I have four little worksheets (one for each sales rep) that all have the same
data (ie. client name, date signed, sales amount, etc). I want to have a "total" worksheet that will not only summarize all of the individual sales persons data, but have the summary sheet automatically update when each individual sales sheet is updated. I do not know how to use pivot tables, macros, or consolidation. Please note that this office does not have MS Access. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Worksheets
hi busybee0279
You can start here (code example) http://www.rondebruin.nl/copy2.htm See David McRitchie's site if you just started with VBA http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "busybee0279" wrote in message ... I have four little worksheets (one for each sales rep) that all have the same data (ie. client name, date signed, sales amount, etc). I want to have a "total" worksheet that will not only summarize all of the individual sales persons data, but have the summary sheet automatically update when each individual sales sheet is updated. I do not know how to use pivot tables, macros, or consolidation. Please note that this office does not have MS Access. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions | |||
Combining 2 or more worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions |