Data entered in one sheet automatically appearing in a master sheet

Report
Posts
2
Registration date
Monday January 18, 2021
Status
Member
Last seen
January 18, 2021
-
Posts
2701
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 1, 2021
-
I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of inventory items i.e. publications/images;

I need to set it up so that any new data entered into the new separate sheets is automatically entered into the master sheet,

Can anyone advise how I might set this up.
Thanks in advance
Dave

1 reply

Posts
2701
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 1, 2021
457
Hi Researcher,

I would advise to do the reverse, populate your master sheet and let Excel fill in the sub sheets. You can read here how to do that:
https://ccm.net/faq/55882-how-to-auto-transfer-data-from-master-to-sub-sheets-in-excel

If this doesn't work for you, then let us know how your sheets are made up, so we know which data needs to go where.

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!