Forum Discussion
Need to create Master Spreadsheet w/ Directory Referenced.
Currently, at work, we use several spreadsheets to compile similar data. We are opening a new office, so I'd like to start fresh with a workbook that would have a master sheet and then department-spe...
The solution you receive will depend on the version of Excel you're using. If you have access to Office 365 and dynamic arrays, this can be done elegantly with FILTER (and even taking it a step further to pull the criteria from the sheet name).
If not on 365, it can still be done. There are a few ways.