Forum Discussion
Connecting Excel Sheets
So, I'm not sure if this is something I can do or not. I help run a club and each member of the organization has their own spreadsheet that tracks what events they go to. So, for example, ...
I would not have multiple sheets with the data. Use only one sheet for the data and then use the reporting Tools to provide the details for each Member.
For the Report side there are a number of options. Pivot Tables is my first choice though using Advanced Filters is an option.
With Excel 2013 and later, you could easily filter in Place if the data is in a proper Table using Table Slicers.