Forum Discussion

Thomas Fallon's avatar
Thomas Fallon
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 where I would mark with an 'X' that I want that data transposed.  I want all data rows with an x in that third column to be copied to another worksheet, skipping lines without the X (but not having a blank, just moving onto the next X).  First page of the attachment is the data sheet.  Second pageis how this would transpose correctly.

5 Replies

    • Thomas Fallon's avatar
      Thomas Fallon
      Copper Contributor

      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's avatar
        SergeiBaklan
        Diamond Contributor

        Thomas Fallon ,

         

        Thomas, to show update click on ribbon Data->Refresh All. Or right click on resulting table and Refresh.

Resources