1hyperlink and macros

[Randy]

I have an equipment data base file that contains a column with
individual unit numbers for each piece of equipment (seperate unit
number for each line item).
What I'd like to do is be able to click on the unit number and have
the hyperlink take me to another work sheet in the work book that
contains individual components for each piece of equipment, e.g., in
cell A2 of the Equipment worksheet is a truck with Unit No 120.
When I click on Unit 120 it takes me to the component worksheet and
filters
the sheet for Unit 120 so that all I see are the components of that
unit number.
Bare with me on this as I'm not that familiar creating functions like
this. I'd like a way to do this without having to use VB as I'm not
familiar with it.
I know how to create the hyperlink but I'm lost after that.
I appreciate any help on this.

 

[Shane Devenshire]

Hi,

If you know how to create the hyperlink, the only other thing you need it to
have set up auto filter on the appropriate sheet. Suppose your sheet that
the hyperlink takes you to is Sheet3 with titles on row 1 and data below.
Put your cursor in the data of Sheet3 and choose Data, Filter, AutoFilter.

Now when your hyperlink takes you to Sheet3 you will open the autofilter
drop down and choose the item you want to display.

However, without VBA you can not make this process of auto filtering
automatic.

 

[Randy]

Hi,

If you know how to create the hyperlink, the only other thing you need itto
have set up auto filter on the appropriate sheet.  Suppose your sheet that
the hyperlink takes you to is Sheet3 with titles on row 1 and data below. 
Put your cursor in the data of Sheet3 and choose Data, Filter, AutoFilter..  

Now when your hyperlink takes you to Sheet3 you will open the autofilter
drop down and choose the item you want to display.

However, without VBA you can not make this process of auto filtering
automatic.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire





- Show quoted text

Shane, can you give me a simple VBA "equation" that will take care of
this, or would there have to be a different equation for each unit
number that I wanted filtered in the other work sheet?
Thanks for the reply.