Forum Discussion
EXCEL - How to have data from spreadsheet automatically update on separate spreadsheet
I have a master spreadsheet for information. There are not formulas, just data. I would like to have secondary spreadsheets that break down this data into separate categories but when the data on the master is changed it is also changed on the secondary sheet as well.
1 Reply
Hi, the master sheet must include a unique key column id. Formulas such as VLOOKUP or XLOOKUP are used in the secondary sheet to retrieve information based on that id
This way, any changes made in the master sheet are automatically reflected in the secondary sheet
