Forum Discussion
Can I live query part of a sheet into another?
I'll try to keep the description simple.
Sheet 1 contains performance data about past projects. Each row is a separate project. (Column A is 'project number' and O is profitability)
I'd l...
You can add your extra sheets and then use an array formulas to populate data from the master. Here are two examples of what I think you are looking to do:
http://sfmagazine.com/wp-content/uploads/sfarchive/2013/09/EXCEL-Extracting-Matching-Records-with-an-Array-Formula.pdf
https://www.get-digital-help.com/2009/09/28/extract-all-rows-from-a-range-that-meet-criteria-in-one-column-in-excel/
The more detail the community has the easier it is to answer your inquiry. If you post a sample workbook with non-sensitive or mock up data it will be easier to assist in giving you a solution.