Adding a filter...

[Finalfrontier1976]

Hi All,

On the attached spreadsheet I have a 12 tables on one sheet. What I want to do is apply a filter so that when choosing the area name (in yellow in each table) that table and it's values will be shown. Basically looking for a faster way instead of scrolling down.

Any ideas?

Thanks,
Lew

[ARGK]

Hi Fellow West Midlandian
Please find herewith your solution. Simply click on any one of the yellow site names and you will be taken to that sites table.
Hope this is what you wanted.
Good luck.
Tony

[Finalfrontier1976]

Hi Tony,

Thanks very much for that, appreaciated.

Lew

[ARGK]

You're welcome Lew.
Tony

[Finalfrontier1976]

Hi,

Is there a quick way to repeat the Links to Depot headers (row 3) again and again (with the links still intact) all the way to Week 52, which is the end of the year.

Lew

[ARGK]

Hi Lew
Please find attached modified workbook.
Kind regards
Tony

[ChemistB]

ARGK's solution is a good one. But since I like to give options. Here's one in which the data is brought to you (VIA INDEX/MATCH) instead of you going to the data. I created an empty table with a dropdown in B7. Choose from that dropdown to populate the table. (I populated Raunds Table to make sure it works)

[newdoverman]

Here is yet another way of addressing this problem. It uses named ranges for the various areas.