Aug 10 2020 01:20 PM
Hi All,
I not the most tech savvy guy out here when it comes to excel but I need your help. I'm used to basic formulas but i've not been able to find a way around this task. I have a workbook with various sheets on it. My primary goal is to ensure that as each sheet is filled, the data there is reflected on the master sheet. I have attached the spreadsheet, if it is a formula required or working with Query, please advise on how to get this spreadsheet to work.
Thank you!
Aug 10 2020 04:14 PM
Hello @PNEME82 ,
in most cases, duplicating data is not required if you follow the principles of good data architecture.
Instead of entering data into the numerous sheets, consider entering data just ONCE, in the Master sheet. Then you can set up a report to create filtered lists for different groups of people, based on the group they belong to. You need to add a column to the master sheet, then add all the data to that sheet.
Next, create a pivot table with all the columns you want to show. Use the new group column as a slicer.
Now you only need ONE sheet to report on the different groups of people and no data needs to be duplicated or copied.
Sep 02 2020 12:17 PM