Forum Discussion

Takhisis4tw's avatar
Takhisis4tw
Copper Contributor
May 18, 2023
Solved

Auto-populate smaller table from larger table

Hi,   I have a ridiculously large table with an insane amount of information in it that is required for me to have an overall look at all people requiring work to be completed or not, and all detai...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    May 18, 2023

    Takhisis4tw 

    An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

     

    Information of rows that have YES in column H is returned in the green table. If you work with Office 365 or Excel 2021 you can apply the FILTER function. FILTER function updates without having to refresh.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 18, 2023

Takhisis4tw 

An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

 

Information of rows that have YES in column H is returned in the green table. If you work with Office 365 or Excel 2021 you can apply the FILTER function. FILTER function updates without having to refresh.

Resources