I would be very grateful if someone could help me with a solution for the issue outlined below.
I have a list of names in cells F3:F945 in a worksheet called ‘index’.
On another worksheet (in the same workbook) called ‘Macro Moths’, as I type into cell D3 I would like a drop-down box to appear containing suggested names from cells F3:F945 in the ‘index’ worksheet.
I would rather not be involved with using code; if possible formula would be better in this instance.
I am using Excel 2003, thanks.
Hawkmoth1
Bookmarks