Referencing Data Filter to a cell value

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
Richard -

Can't you just set up an autofilter in the sheet? It creates its own
drop downs, and it can base the filter on the actual names, not on
hidden dummy numbers. It's easy enough to do (read the help files, or
better yet, look at Deb Dalgleish's tutorial at
http://www.contextures.com/xlautofilter01.html).

- Jon
 
Back
Top