Forum Discussion
Solved
Show data on another sheet if it matches the criteria.
So I have a spreadsheet with a huge list of projects (almost 300 rows and growing). To help organize this information, I want to separate the projects into new sheets within the same workbook. i.e., ...
Take a look at the relatively new FILTER function. Here's a YouTube video that explains it. As I understand your situation, this would be perfect. Set whatever criteria you want for those derivative spreadsheets, and FILTER will deliver the relevant rows from your master database. (You will need a new version of Excel)
https://www.youtube.com/watch?v=9I9DtFOVPIg
Take a look at the relatively new FILTER function. Here's a YouTube video that explains it. As I understand your situation, this would be perfect. Set whatever criteria you want for those derivative spreadsheets, and FILTER will deliver the relevant rows from your master database. (You will need a new version of Excel)
https://www.youtube.com/watch?v=9I9DtFOVPIg