Inserting a row in all sheets at the same time
 

Can someone help?

I have a workbook with several sheets, where the first three columns of
each sheet are the same, and are supposed to have exactly the same
contents.

I have linked all the cells to the ones on the first sheet, but I need
to be able to insert a row somewhere in the first sheet, and that that
row is automatically inserted in all the ohter sheets in the workbook.

Is this possible? Does anyone know of a VBA script or a macro to do
this? I tried doing it with a macro, but it does not do it
automatically and also only inserts a specific row as saved in the
macro.

Thanks,

Nuno Eça




--
nunoeca
------------------------------------------------------------------------
nunoeca's Profile: http://www.excelforum.com/member.php...o&userid=26200
View this thread: http://www.excelforum.com/showthread...hreadid=395063

Inserting a row in all sheets at the same time
 

munoeca, you don't need a macro, group the sheets, right click and select
all sheets, insert your row, it will be inserted in all sheets, don't forget
to ungroup the sheets when you are done.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"nunoeca" wrote in
message ...

Can someone help?

I have a workbook with several sheets, where the first three columns of
each sheet are the same, and are supposed to have exactly the same
contents.

I have linked all the cells to the ones on the first sheet, but I need
to be able to insert a row somewhere in the first sheet, and that that
row is automatically inserted in all the ohter sheets in the workbook.

Is this possible? Does anyone know of a VBA script or a macro to do
this? I tried doing it with a macro, but it does not do it
automatically and also only inserts a specific row as saved in the
macro.

Thanks,

Nuno Eça




--
nunoeca
------------------------------------------------------------------------
nunoeca's Profile:
http://www.excelforum.com/member.php...o&userid=26200
View this thread: http://www.excelforum.com/showthread...hreadid=395063

Inserting a row in all sheets at the same time
 

Did you try grouping all tabs in the spreadsheet? If the sheets have
the same format and the data is in the same row on all of them you can
goto to the 1st sheet then press the shift key and click on the last
sheet ( to group them) then in your 1st sheet do insert row. Ungroup
the sheets and you will see the new row on each of the sheets you had
grouped.

Hope this is what you want.

Regards.


--
cafe
------------------------------------------------------------------------
cafe's Profile: http://www.excelforum.com/member.php...o&userid=16145
View this thread: http://www.excelforum.com/showthread...hreadid=395063