Hi,
I have a sheet where Column A is updated with individual names from a Names List on a regular basis and so there will be lots of repetition as the list gets bigger. I need to extract the unique names and show them in a different column. I've scoured the internet and every formula that I have found doesn't seem to work so I thought some VBA / Macro (not my forte) would work. So far, in a Worksheet_Change sub I have:
Which works, UNLESS:
1) as soon as the data from Column A is deleted (i.e. if entered by mistake and deleted rather than replaced) OR
2) any other worksheet change event (such as entering data elsewhere in the worksheet)
I get a Run-time error '1004': "the extract range has a missing or illegal field name". This shouldn't be a problem too often as 'A' should be the first data entered, but as it's not just going to be me using this, I'd like to put something in place that fixes this but my coding skills are not great.
Any help would be much appreciated.
Thanks,
Bookmarks