Create new table without formulas based on data from another spreadsheet.

[Jaffabfc]

HI,

I have a spreadsheet with several thousand rows and columns A to T.

I can create a pivot table with the pivot columns been A:B, i am wanting to filter via unique data in column H.

So if Column H2:H10 equals "Red" i want a copy of the pivot created going into a seperate spreadsheet called Red as a table with as text.

Then the aim is once all complete these will send via powerautomate to unique email addresses as a Excel attachment example red attachment sending to red@red.com

Hopefully above makes sense.

Thanks