inserting rows in linked worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have worksheet "1" as my master worksheet with other worksheets linking to
its data. When i instert a new row in worksheet "1" i dont see the new row in
the other worksheets that are linked to it....how can i accomplish inserting
new rows in worksheet "1" so that all other worksheets get the same new row
inserted???
 
If the sheets are all in the same workbook, select sheet 1, select the
line where you want to insert a line, select all the sheets and perform
the insert. Excel will insert a line at the same point in all selected
sheets. If you right click a sheet tab you can select "select all
sheets".

Hans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop linked cells from changing when insert new row? 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Formula from consecutive rows to alternate rows? 2
Sorting non-linked cells in a linked worksheet 1
VBA - retrieve data on last create named range from previous inserted named range 0
Linking worksheets, rearranging rows. 1
Inserting Rows into multiple worksheets 2
Sorting in multiple worksheets 1

Back
Top