Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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

Answer 1 / 1
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
Comment
1
Thank you
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

Reply Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!