[SOLVED] adding rows across multiple worksheets within a single workbook

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

f.freeman@usa.net

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" <frank.freeman@discussions.microsoft.com> wrote in message
news:57B2254D-AFB7-4AA0-B7EE-ECE701208750@microsoft.com...
> 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
>
> f.freeman@usa.net
>
>