Automate searching and copying information from a file to another

**d1rt** · 05-22-2012, 03:20 PM

Hello,

I've been looking for this for a few days now, but I don't have any programming skills nor I've never used a macro in excel so I ended here and wanted to ask if someone could help me or can let me know if this work can be done in excel.

I have two excel files, one with the complete information (File A) and the other one that I have to complete manually one by one (File B)... This work consist in looking for an e-mail from file B and searching the same mail in the file B and complete for example, the columns B, C and D, and so on with the following mails.

It's difficult to me to figure out how to automate this because it's not just making it to fill for example information that is in column A and place it on column B in the other file.

I hope someone could help me with this, I'll really appreciate it.

Ed

**arlu1201** · 05-22-2012, 03:26 PM

It will be good if you explain with the help of a sample excel file.

To Attach a File:

1. Click on Go Advanced.
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**d1rt** · 05-22-2012, 04:26 PM

Ok, thanks for your response. I've attached my two example files. I marked in green the cells that need to be filled with the information. So you pick the e-mail and search on the other file to match the same email and start the process. Also the file A has a few tabs so the search should be done in entire book.

**d1rt** · 05-23-2012, 04:28 PM

I hope anyone can help me with this. I really need it for my work.

**arlu1201** · 05-24-2012, 03:37 AM

Are there chances of the same email being duplicated in file A or B?

**d1rt** · 05-24-2012, 11:04 AM

Hmm yes, there's a minimum chance that the mail is duplicated in file A. But it has to pick the first e-mail that matches the search and start the process.