adding rows across multiple worksheets within a single workbook

[Guest]

I am attempting to creat a workbook in excell 2003 pro which contains several
worksheets. all of the worksheets contain the same names in the first column
and the data in the following colums is manipulated with summeries of the
columns on the last sheet. that part is not a problem. my problem is that if
i add a row to the first sheet in the middle of the rows of data i need the
workbook to add the rows to the other sheets in the same place mailtaining
the same formulas/relationships.

any help would be appreciated

(e-mail address removed)

 

[Tom Ogilvy]

Assume you are doing this manually:

group the appropriate sheets before you insert the rows and put in the
formulas.