Microsoft Office Forums - View Single Post

Pecoflyer · 03-23-2024, 08:58 AM

Attached a solution using Power Query ( it's called Get and Transform in 2019 I think).
In this file you can add/delete/modify rows to the main tab and just hit " Refresh" to update the AGS tab.
For the benefit of members unable/unwilling to open the file here is the code

Code:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filtered Rows" = Table.SelectRows(Source, each ([Type] = "AGS"))
in
    #"Filtered Rows"