Hello, I have a database of email addresses hyperlinks, that a department
needs to do an advanced filter (extract) on so they can copy the data to a
new file to be emailed out. However when you extract the data using the
advanced filter, the extracted data is no longer hyperlinked to the email
address.

Ordinarily i would just use Hyperlink(extractedcolumn) to fix this, but I
wanted a more automated solution since the data needs to be copied to a new
workbook (book1, book2, etc) so they can save the new file with a new name.

Thanks in advance for any suggestions!

ITD3