ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to insert a copied row into all aother tabbed table (https://www.excelbanter.com/excel-discussion-misc-queries/265244-there-way-insert-copied-row-into-all-aother-tabbed-table.html)

Greg

Is there a way to insert a copied row into all aother tabbed table
 
I have a file with about 100 tabs along the bottom for other tables. I have
a row that I need to copy and insert into each one of those (at the top,
first row). I can copy and insert row into each tab individually but is
there a way to have this insert into all of them at once in the same place?

David Biddulph[_2_]

Is there a way to insert a copied row into all aother tabbed table
 
Yes. Group the sheets.

For Excel help on how to group sheets, type "group sheets" into Excel help.
--
David Biddulph


"Greg" wrote in message
...
I have a file with about 100 tabs along the bottom for other tables. I
have
a row that I need to copy and insert into each one of those (at the top,
first row). I can copy and insert row into each tab individually but is
there a way to have this insert into all of them at once in the same
place?





All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com