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

Report
Posts
1
Registration date
Tuesday January 19, 2021
Status
Member
Last seen
January 19, 2021
-
Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
-
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?

1 reply

Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 28, 2021
457
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
Thank you

Glad we were able to help! Love us? Write us a review! Rate CCM

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!