Add row to linked sheets

Occasional Visitor

I am making liquor inventory sheets and have a master sheet with all my inventory and a sheet for each month. How can I add new items to the master sheet so it will automatically update the sheets with the months? Thanks

1 Reply


Quick solution proposal:

Of course, it only works if all the leaves to be treated have the same structure.

And by “the same” we mean “exactly the same” up to a certain point!

Example in the sheets January to December a new line appears below the line in all sheets the same.

The key is:

As long as several worksheet (tabs) are selected, Excel does everything you do in the January sheet, for example, in all other selected sheets at the same time.

So do you want to insert the line in all tabs?

Click on the January sheet, hold Shift and click on the December sheet.

Now all leaves from January to December are marked.

If you only want to select a few of several sheets, instead press and hold the Ctrl key and click on the sheets to be selected one after the other.


Hope I was able to help you with this info.



I know I don't know anything (Socrates)


* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.