If condition before data gets dropped into PIVOT

[pdalal]

I have a pivot table code that I am trying to modify slightly.

In my data file where the column header is deck , before doing the pivot I want it to look at line 1 where the column headers are upto the last line where data is and if deck=A delete the entire row.

Help PLease !

Please Login or Register  to view this content.

[pdalal]

"Bump no response"

[pdalal]

"Bump no response"