Assume you are doing this manually:

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

--
Regards,
Tom Ogilvy

"frank.freeman" wrote in message
...
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