Hi all,

I have a cell in a spreadsheet "sheet1" which when you put your go to that
cell i.e. cell "A1", it gives you the option to select from a dropdown menu
a list of occupations which is in "sheet2".

There is no macro associated with it and its not a combo box or a list box
that you can draw, in a sheet and link to a specific list of occupations so
that a combo box e.g. can display.

It looks like some kind of filter embeded in the cell.

If someone can help it will really be appreciated as this thing is driving
me crazy. If anyone would prefer I can sent the excel file for review.

Thanks
Pantelis