Data Exported From One Excel File To Another

Anyone know how to export excel data from one cell of the same file, to ANOTHER excel spreadsheet?

I want to collect email addresses for my job, and every time I use a certain excel file, which is an insurance rate sheet, I always enter the client's email address in the same cell. I would like this email address that I enter to be exported to whole different excel spreadsheet so I can build an email database of my clients.

Is something like this possible?

Thanks.

WOW! That's great, and simple!

Thank you!

Ooops, I forgot. One more question please...

If I use the formula you mention above it will keep overwriting the same cell. But I need to build a list of email addresses so I need the destination workbork to LIST the entries in a column starting in a1, and then going to a2, a3...etc.

I would also NOT like to have any duplicate entries.

Is there any way to do this?

Thank you so much for your help. It'll really make me look like a champ at work if I can get this going!

Originally Posted by Carim

Hi,

In your destination worksheet, place yourself in cell A1 ...
and copy formula all the way down ...

Hi Carim, thanks for the response.

Unfortunately if I do it the way you mention, then every time I enter an email address on my original spreadsheet then ALL of the cells on my destination spreadsheet will change to that email address.

I need to enter an email adress on my original spreadsheet, and then have it go to the destination spreadsheet. Then, the next time I use my same original spreadsheet and enter another email address, I want that email address to line up under the previous one on the destination spreadsheet.

I'm building a database of email addresses so I want them all to line up in the same column on the destination spreadsheet.

I hope this makes sense

Thank you for your help!