ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding rows to tables in 2 different sheets (https://www.excelbanter.com/excel-discussion-misc-queries/153179-adding-rows-tables-2-different-sheets.html)

birdpants

Adding rows to tables in 2 different sheets
 
Hi - is there a way to add a row to a table that is located on 2 different
sheets at the same time?

challa prabhu

Adding rows to tables in 2 different sheets
 
Hi,

You can group the worksheet tab by the pressing the CTRL key, and then
insert enter few rows in one sheet. This automatically insert the same number
of rows in the same location in the other sheet.

Then right-click the sheet tab and select Ungroup Sheets to deselct the
grouped sheets.

Challa Prabhu

"birdpants" wrote:

Hi - is there a way to add a row to a table that is located on 2 different
sheets at the same time?



All times are GMT +1. The time now is 08:28 AM.

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