| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine 2 sheets into 1 that will update w/new data
I have two worksheets that data is enterd onto twice a month each wprksheet
has a set of columns that summaraizes and performs calculations on the data enterd. I would like to combine the summarized columns into one master sheet and have them be updated when data is enterd bi-monthly onto the primary sheets. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine 2 sheets into 1 that will update w/new data
I think this will work for you:
http://office.microsoft.com/en-us/ex...548301033.aspx "Ms. Von" wrote: I have two worksheets that data is enterd onto twice a month each wprksheet has a set of columns that summaraizes and performs calculations on the data enterd. I would like to combine the summarized columns into one master sheet and have them be updated when data is enterd bi-monthly onto the primary sheets. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine 2 sheets into 1 that will update w/new data
Nate, I do not want to combine them to print them i think you mis-read my
question i want to combine the data from two separate worksheets in the same workbook INTO 1 WORKSHEET -- THAT WILL UPDATE ITSELF -- WHEN NEW DATA IS ENTERED ONTO EACH OF THE INDIVIDUAL WORKSHEETS!! "Nate" wrote: I think this will work for you: http://office.microsoft.com/en-us/ex...548301033.aspx "Ms. Von" wrote: I have two worksheets that data is enterd onto twice a month each wprksheet has a set of columns that summaraizes and performs calculations on the data enterd. I would like to combine the summarized columns into one master sheet and have them be updated when data is enterd bi-monthly onto the primary sheets. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple sheets of data into one worksheet | Excel Discussion (Misc queries) | |||
| How do I combine data from several sheets into one main sheet? | Excel Worksheet Functions | |||
| combine data from multiple sheets | Excel Discussion (Misc queries) | |||
| How do I combine and match data from 2 sheets | Excel Discussion (Misc queries) | |||
| How to append/combine (not add) data in several sheets into one? | Excel Discussion (Misc queries) | |||
Hybrid Mode
