How can I add a search box to a spreadsheet whereby:
- User types name in cell (say, cell D1 and then button assigned to macro is clicked)
- Column A is queried for value typed in D1
- Value matched in Column A is selected

Thanks.

EU