Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Rows into multiple worksheets
I have a number of linked worksheets & would like to know if its possible &
how, to insert a row into one sheet it will auotmatically insert a row into the corresponding linked sheet with the same formatting. Ideally it might also allow for automatically updating the numbering (in the 1st column) similar to when inserting number bullets in word. Any suggestions & help appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Rows into multiple worksheets
Are you talking about separate files or multiple worksheets in the same file?
If it's the latter, If you hold down the shift or control key and click on the tab for each worksheet you want to activate, then when you insert rows, or add data to your main sheet, each sheet that has been selected will be updated accordingly. I don't know if this meets your definition of automatic. Search for "select on or multiple worksheets in help. I don't believe this can be accomplished in separate files and I haven't tried it. "Andrew" wrote: I have a number of linked worksheets & would like to know if its possible & how, to insert a row into one sheet it will auotmatically insert a row into the corresponding linked sheet with the same formatting. Ideally it might also allow for automatically updating the numbering (in the 1st column) similar to when inserting number bullets in word. Any suggestions & help appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Rows into multiple worksheets
Thanks, that works however I now realize that where i want to input the data
is on a different row number in each sheet ie; sheet 1 row 50, links to sheet 2 row 234 so if i insert above row 50 on 1st sheet i would like to automaticaly insert a row above row 234 on second sheet. As i said before it would be really good if it updated the sequental numbering in the 1st column and maintained the formatting. I could name/define the range if that was advantageous. Any help appreciated????? "bman" wrote: Are you talking about separate files or multiple worksheets in the same file? If it's the latter, If you hold down the shift or control key and click on the tab for each worksheet you want to activate, then when you insert rows, or add data to your main sheet, each sheet that has been selected will be updated accordingly. I don't know if this meets your definition of automatic. Search for "select on or multiple worksheets in help. I don't believe this can be accomplished in separate files and I haven't tried it. "Andrew" wrote: I have a number of linked worksheets & would like to know if its possible & how, to insert a row into one sheet it will auotmatically insert a row into the corresponding linked sheet with the same formatting. Ideally it might also allow for automatically updating the numbering (in the 1st column) similar to when inserting number bullets in word. Any suggestions & help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting rows on multiple worksheets | Excel Worksheet Functions | |||
inserting rows on multiple worksheets | Excel Worksheet Functions | |||
Inserting columns & rows in worksheets | Excel Worksheet Functions | |||
inserting rows in linked worksheets | Excel Discussion (Misc queries) | |||
Inserting rows into worksheets that are protected | Excel Worksheet Functions |