Flurry,

I think that "Macro 1" that I posted above would work well for the
copying you want to do. I have used it before. You would need to
change the column searched and the search value. See line 18--the
default is Column E and "Mail Box".

Regards,

Don