Entire tables inside a filter, possible?

Hi all, 

I’ve recently been tasked with a bit of a difficult situation at work. We have a pricing tool that is essentially a bunch of excel pages each with variations of pricing tables on, there is too much variation of types of information to create a table using data validation and such methods, so I was wondering if there would be a way to create a filter that drops down an entire table from the workbook based on the title/product of the table. 

 

Thanks for any help you may have, it is greatly appreciated as I’m hardstuck on where to go about this, or whether it might already be as simple as it can get.

 

Cheers,

Joe

By: Joe

Leave a Reply

Your email address will not be published. Required fields are marked *