[RESOLVED] Showdetail of Pivot table values based on criteria

[abhay_547]

On more thing, though, Is it possible to add a last column in the end after copying the data to newsheet, with the text "Match 1", "Match 2" and so on, as shown in the below snapshot.


Also can we paste special values while pasting the tables into newsheet and ignore headers as well by offsetting rows while copying (except for first dup set), or we have to copy the data from the newsheet and paste it into another sheet to do the same and remove the header like below.

Sheets("newsheet").Select
Cells.Select
Selection.Copy
Sheets.Add
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False