Referencing Cell Value using Data Filter

[Richard]

I am having continuing problems with the following:

I have a spreadsheet which lists project status. One of
the columns shows the installation subcontractor.
I want to have a drop down box where you select the
contractor, and once selected, the list automatically (or
by use of a macro button) filters to that selected. I
have put the drop down box in, then created a vlookup to
convert each contractor to a number, and placed a hidden
column with this info. Where i am stuck is how i get the
data filter to look at my link cell from the drop down
box.

Any help is appreciated

Richard

 

[Bob Phillips]

Richard,

I have an example workbook that demonstrates this technique. It uses VBA.
Mail me directly if you want a copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)