Thanks for the response Bob,
I need something that will work for a generic list where unique items in
column B populate the combo box. This is key, can I do this with data
validation given that the list on sheet 2 is a dumped list where the values
change 3 or 4 times a day?
--
Thanks,
MarkN


"Bob Phillips" wrote:

Use data validation rather than a combobox, as this uses a cell on the
worksheet rather than an object off the worksheet. You can then use VLOOKUP
formulae to look into your table, using the value selected from the DV cell.
If using a range on another worksheet to populate the DV, name that range,
and use that name in DV, else you will get an error.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MarkN" wrote in message
...
Simplistically, my problem is this:

I would like to be able to put a combo box on sheet 1 that will allow a
user
to select a choice (the combo box should be populated with unique records
from sheet 2, column b). Once a choice has been selected, all matching
records from sheet 2 will be displayed on sheet 1.

If anyone can point me in the direction of a similar example I would be
grateful.
--
Thanks,
MarkN