Macros are generally my solution of choice for most anything I, (or my users)
have to do frequently.

Vaya con Dios,
Chuck, CABGx3



"Mac" wrote:

Thanks for the reply Chuck. I was trying to keep it simple (i.e. hit
F9 and there's your list) mainly because it's going to a receptionist
who can't get too involved with the spreadsheet technically.

The more I play around with this, I don't think I can keep it to one
hot-key or click in Excel and achieve the desired results. I was
trying to avoid a macro route as well because this spreadsheet could
change hands between personnel and it could get lost, but that may be
the better option.