Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheets
I have 4 worksheets 1,2,3 & a Summary. Worksheets 1,2,& 3 tie into the
Summary. Is there a way to add or delete rows in 1,2, or 3 so that the same change is picked up in the summary sheet so that I do not get an error message in the summary worksheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheets
Kacey
Are you wanting to delete one or more rows in any one of the other sheets and automatically delete the same rows in the summary sheet? That doesn't sound logical. What do you mean by "so that the same change is picked up in the summary sheet..."? Provide more information about what you want to do. HTH Otto "Kacey" wrote in message ... I have 4 worksheets 1,2,3 & a Summary. Worksheets 1,2,& 3 tie into the Summary. Is there a way to add or delete rows in 1,2, or 3 so that the same change is picked up in the summary sheet so that I do not get an error message in the summary worksheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Sheets
I tried to delete a row in one sheet but when I do that I get an error
message on my summary sheet. When I delete or add a row in one of the sheets I have to manually delete or add that information to the summary sheet. I was thinking there may be a formula I could use that would update the summary sheet so I won't have to do it manually each time. I know a little more than basic Excel but I have never really worked with formulas. I am using a very simple formula example: =('sheet1'!X97+'sheet2'!X97+'sheet3'!Z97) to get the total in my summary sheet. Any help is greatly appreciated. Kacey "Otto Moehrbach" wrote: Kacey Are you wanting to delete one or more rows in any one of the other sheets and automatically delete the same rows in the summary sheet? That doesn't sound logical. What do you mean by "so that the same change is picked up in the summary sheet..."? Provide more information about what you want to do. HTH Otto "Kacey" wrote in message ... I have 4 worksheets 1,2,3 & a Summary. Worksheets 1,2,& 3 tie into the Summary. Is there a way to add or delete rows in 1,2, or 3 so that the same change is picked up in the summary sheet so that I do not get an error message in the summary worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 03- sheets stay grouped even when I ungroup | Excel Discussion (Misc queries) | |||
How to save sheets in new excel files, automatically? | Excel Worksheet Functions | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel |