You are reading a single comment by @salmonchild and its replies.
Click here to read the full conversation.
-
Unfortunately not, I don't want to summarise the data, rather just show an extract of the table- some cells are text/comments and I need this pulled through. e.g columns A-C,F and K where K=1.
The advanced filters aren't a problem and have worked well for me in the past, but refreshing them is. I really don't want to be tied to updating this workbook so want to hand it over for self service.
salmonchild
rhb
Pivot table with identifier column as Filter?