Newsletter Contact Sheet

Posted by admin in Film Cameras | No comments






Newsletter Contact Sheet
How do I find and list all values in Excel?

I have a workbook with many sheets listing all of the schools my org interacts with. Each sheet lists 1-5 email addresses, depending on how many contacts we have.

I want to have a summary sheet that lists all of the email addresses so it's easy to copy-paste them to send out newsletter.

I did a FIND/REPLACE for "@" and it found all of the email addresses, but it won't let me copy paste them from the search results.

I've also been trying to do reserach on how to do this with a formula, macro, or VB but haven't come across anything.

Thanks!

Here is a simple macro that will help you doing that

http://www.file1.net/project.asp?id=x16f7J2VUPw6aWLP

Enjoy it,, it will copy all rows from all other sheets than the current one into it for manipulating easy

VBAXLMan



Items Recently Purchased From This Site:

MINOLTA Contact Sheet Newsletter #34 1987 President Ronald Reagan & Nancy cover, MINOLTA CLUB NEWSLETTER CONTACT SHEET 1973/116380, MINOLTA CLUB NEWSLETTER CONTACT SHEET 1973/116378, MINOLTA CLUB NEWSLETTER CONTACT SHEET 1974/116377, MINOLTA CLUB NEWSLETTER CONTACT SHEET 1975/116376,
Powered by phpBay Pro

Tags: , , , ,

 


Leave a comment

Please sign in to leave a comment.