MrExcel Publishing
Your One Stop for Excel Tips & Solutions

inserting rows simultaneously on sheet1 & sheet2


Posted by jim on February 07, 2002 10:34 AM

Is it possible that when you insert a row on sheet1 it
inserts a row on sheet2:

If i insert a row on sheet1 at A5, it inserts a row on
sheet2 at A5 (regardless of wher the cursor is on sheet2

Thanks for any thoughts or assistance

Jim


Posted by Paul B on February 07, 2002 10:39 AM

Select sheet1 hold down the control key select sheet 2 insert your rows

Posted by Jim on February 07, 2002 11:03 AM

Thanks Paul,

I didn't bother posting my whole objective
because i didn't know if part 1 was possible.

The second part is copying and pasteing in the
"newly inserted row" the formula from the above
row.

Thanks for any help,
Jim

Posted by Paul B on February 07, 2002 11:27 AM

pressing control & D will copy what is above (NT)

Posted by Jim on February 07, 2002 11:52 AM

Re: pressing control & D will copy what is above (NT)Thanks Paul(nt)

: Select sheet1 hold down the control key select sheet 2 insert your rows