Performing queries between one or more excel files.
I need some help to perform some query using Excel or GoogleSpreadsheet.
Let me explain the problem:
I've got 1 excel file that contain "Company Name", "Company Website" & "Email" (plus other columns not really relevant).
Some companies has got empties values in "Email" field.
So I've used a software to perform a scraping activity.
Basically the software navigate each links and search for email fields.
The output is a new file excel that contain "Company Website" and "Email".
In Total I've got 18 raw excel files plus 18 excel files given from Scraping software.
The goal is to compare/lookup "Company website" from excel file A with "Company Website" from excel file B, If the values are the same we must copy "Email" values from excel file B and append it into excel file A in the correct row.
Check attached examples files
Please ping me for futher info, we can start an Anydesk session in order to show you what is the result I expect.
Thanks everyone for your kindly attention
49 freelancer chào giá trung bình$19 cho công việc này
Hello, I just seen the excel file A which have the websites. Can you please send me the excel file B too? Then I can understand this better. Also if you want I can do some sample work too before starting. Thanks.
Hello there, I will write a code (VBA) in excel throgh which data will be retrieved from one excel file to another by matching.. Looking forward. -Akibul
Dear Sir, I check the example and understand your requirements. I will do it for you in no time and I am sure you will be happy with my work. all I need is a 5 star review. Thanks
Dear, To make the long story short, your task is achivable and I am Spreadsheets expert. I am ready to start working immediately, just share your data. Looking forward to your call. Yours Ahmed Saad
Ready to develop a macro/script tool that will auto compare file A with web search result File B form matched web site name then fill Email field in file A with matched records from File B