Previous Topic Next Topic

Data entered in one sheet automatically appearing in a master sheet

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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
18 Jan 2021 à 12:11
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

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Creating 1 master sheet from data from multiple sheets
ExcelNoNothing -
vcoolio -

1 response
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response