Previous Topic Next Topic

Data entered in one sheet automatically appearing in a master sheet

Solved/Closed
researcher064 Posts 2 Registration date Monday January 18, 2021 Status Member Last seen January 18, 2021 - Jan 18, 2021 at 09:48 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 18, 2021 at 12:11 PM
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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 18, 2021 at 12:11 PM
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/apps-sites/software/1607-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