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?