The only reason is that I wanted the list to constantly be correct, so when
new jobs are added, the list automatically includes them.

But, since I'll be using a macro to copy information into this sheet, then
copy the list of jobs out, I don't see why I can't just add the creation of
an Advanced Filter into the macro. Never used one before, cheers for the help.

"Ron Coderre" wrote:

Is there a reason you can't use Advanced Filter to create a list of the
unique names for you?