Forum Discussion

Scott Smith's avatar
Scott Smith
Copper Contributor
Apr 02, 2018

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 like to create other sheets that are automatically built from subsets of rows pulled from Sheet 1. So, Sheet 2 might only pull in the architectural projects (from col G). Sheet 3 could be only projects for a specific client (from col C).

Any tips?

Thanks!

excel

1 Reply

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Apr 02, 2018

    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.

Resources