Excel / Excel 07 Gurus

[Fishbone†]

I'm creating a spreadsheet for work, and I would like to be able to hyperlink some cells to a separate worksheet. My goal is to allow the user to see a summary of the information in a worksheet, but to be able to click on the location name and see the detail. I know how to hyperlink to the separate worksheet, but in addition I would like it to link to the filtered information. So for example, my detail sheet would have several lines of information for each location that would be summarized in my main worksheet. I would like the user to be able to click on the location name and see the detail sheet filtered for that location only. Is this possible??

Edited to add: Since this information changes weekly, I would prefer not to have to make a separate worksheet for each location. I would rather just have it automatically filter. Not sure if that's even an option, but I thought I'd see if one of my fellow DISers knew.

TIA!

 

[iNTeNSeBLue98]

Not sure if this is the same, but one of the spreadsheets I use at work is set up with a VLOOKUP formula. It reads "sheet 1" based on the information in the formula on "sheet 2". This spreadsheet is updated weekly and new detail overwrites the old.