You are reading a single comment by @rhb 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.

  • My colleagues are on a client site and they won't allow us to setup macro enabled workbooks unfortunately- hence the pain.

About

Avatar for rhb @rhb started