ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   adding rows across multiple worksheets within a single workbook (https://www.excelbanter.com/excel-programming/339751-adding-rows-across-multiple-worksheets-within-single-workbook.html)

frank.freeman

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





Tom Ogilvy

adding rows across multiple worksheets within a single workbook
 
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








All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com