auto insert sheet 2's row when inserting row in sheet 1

**eing** · 07-17-2013, 10:14 AM

I have another problem with my excel..
How I can auto insert the row in sheet 2 if I inserting row in sheet 1..?
something like grouping the tab, but automaticaly..

for example:
I want to insert a row between 4 & 5 in sheet 1.
When I inserting the row, automatically the one in the sheet 2 inserted too..
do you have any bright idea about this please..

**aydeegee** · 07-19-2013, 06:05 AM

Hi eing

To group the second sheet, all you have to do is, while you are in sheet 1, left click on sheet 2 while holding down the the Ctrl key. How much easier do you want it?

The really important thing is to remember to ungroup when you no longer want to have the same data on both sheets

(either right click and ungroup or click on sheet 3 or above)

Regards
Alastair

**eing** · 07-19-2013, 07:35 AM

The really important thing is to remember to ungroup when you no longer want to have the same data on both sheets

That's the problem..

But don't worry..
I'd already have the solution for this thread..
check this link:
http://www.excelforum.com/excel-prog...67#post3327467

thanks for the replying this thread..