Forum Discussion

Copper Contributor

May 30, 2019

Solved

Copy Data to Other Sheets' Columns Based on Criteria

Apologies if this is answered. The search I did found similar items but not the result I'm looking for. For simplicity, let's say I have three columns. The first two are data and the third is wher...

Keyed notes.pdf36 KB

excel

Formulas and Functions

SergeiBaklan
May 30, 2019
Thomas Fallon ,

Hi Thomas,

The easiest is with Power Query - query source data, filter and land result back. Sample attached.
Flat Plan.xlsx17 KB

SergeiBaklan

Diamond Contributor

May 30, 2019

Thomas Fallon ,

Hi Thomas,

The easiest is with Power Query - query source data, filter and land result back. Sample attached.

Flat Plan.xlsx17 KB

Thomas Fallon
Copper Contributor
May 30, 2019
SergeiBaklan Thank you Sergei - it does not appear that if I make a change to the original table, that the queries update? (note I have kept the queries in the same Workbook, on a separate Sheet).
- SergeiBaklan
  Diamond Contributor
  May 30, 2019
  Thomas Fallon ,
  
  Thomas, to show update click on ribbon Data->Refresh All. Or right click on resulting table and Refresh.
  - Thomas Fallon
    Copper Contributor
    May 30, 2019
    SergeiBaklan Thank you. That does work, but I was hoping for an automatic update. The people in my office will not know to click refresh (and in fact I'm keeping them out of the excel so they will only see what is referenced into our AutoCAD file from excel). But I can make do with this if there is no easy way to auto update.