Extract rows in Pivot Table for Specicic Columns

Topic

New Reply

I have a Pivot Table “Pivot by Filter” and need code to copy rows with the the following headings “Vat Input” and “Vat output” and to paste these as followsL:

1) Where there are values under Vat Input on sheet “Pivot By Filter” , I need to copy all the rows where there are values in Col “Vat Input” and paste these on sheet “Vat Input”
2) Where there are values under Vat Output on sheet “Pivot By Filter” , I need to copy all the rows where there are values in Col “Vat Output” and paste these on sheet “Vat Output”

I have manually extracted this on Sheets “Vat Input” and “Vat output”

Your assistance in this regard is most appreciated

Reply | Quote