Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I combine multiple worksheets into a single workbook? | Excel Discussion (Misc queries) | |||
Adding rows to multiple worksheets at once | Excel Worksheet Functions | |||
Viewing multiple rows of worksheets in a workbook | Excel Discussion (Misc queries) | |||
sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions |