Populate multiple tabs in an excel spreadsheet based on changes to main tab

Solved/Closed
djhenry66 Posts 1 Registration date Tuesday January 19, 2021 Status Member Last seen January 19, 2021 - Jan 19, 2021 at 02:25 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 28, 2021 at 11:51 AM
We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of items purchase and number issued. We then have tabs set up for each one of our departments also set up and they are identical to the main inventory tab. When we use a new supply we have to insert a row into the main inventory tab and enter all the information, we then go into the 15 different department tabs and insert a row at the same spot and enter all the information. We do this for each tab. Is there a way, when we insert a row and information in the main tab, all the department tabs will automatically insert a row with the same information?
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 28, 2021 at 11:51 AM
Hi Djhenry,

When you right-click a sheets tab, you can select all sheets. When you have done that, you can insert a row and enter all the information and all sheets wil contain that information.

Best regards,
Trowa
1