I am trying to follow hyperlink to autofilter but I cannot

**TRob205** · 12-20-2013, 10:50 AM

I have one worksheet named "stores" that has a list of store numbers (column A) and a second worksheet named "tickets" that contains a list of all store issues but in order to filter the issues to one store I would need to filter column P (as this is where the numbers are displayed on the second worksheet). I have converted all of the store numbers in column A to hyperlinks that go to the Tickets worksheet column P1. Which works fine, I would like to be able to click the hyperlink on the stores worksheet and it autofilter the tickets worksheet to only see tickets related to this store.

I have racked my brain for 2 days reading up on VBA and using google to accomplish this. I have tried to record a macro but when I run the macro it always filters to the store that I created the macro for. This is the macro I created:

Please Login or Register  to view this content.

I have been reading on the follow hyperlink method but I am dead in the water, I am a complete newbie when it comes to VB codes.

Any help is greatly appreciated.