Data entered in one sheet automatically appearing in a master sheetSolved/Closed

Question

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

TrowaD · Answer

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

Data entered in one sheet automatically appearing in a master sheet

1 response

Similar discussions

Subscribe To Our Newsletter!