I have a spreadsheet which lists clients' names in Column A. When I add a
new on at the bottom, I need to quickly check that the name is not an
existing customer i.e. already on the list above.

I have tried to record a macro which copies the selected cell, and then
tries to find any other entries with the same name on the sheet (using the
Find... function on the edit menu) but the macro only seems to record the
'copy' command and nothing after that.

Does anyone know how to get round this please?

TIA

V