Đã hoàn thành

Performing queries between one or more excel files

Performing queries between one or more excel files.

Hi everyone,

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

Kĩ năng: Excel, Excel VBA, Excel Macros, Google Spreadsheets, Data Management

Về khách hàng:
( 9 nhận xét ) Napoli, Italy

ID dự án: #34006143

Được trao cho:

rylkov

Hi, I'm sure that I have enough experience to implement Excel Macros for you needs. You can see in my profile that I implemented several projects related with Excel. You could give me all files, create milestone and I Thêm

$25 USD trong 1 ngày
(2 Đánh Giá)
2.3

49 freelancer chào giá trung bình$19 cho công việc này

(482 Nhận xét)
8.3
RSUKANTA2014

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.

$25 USD trong 1 ngày
(374 Nhận xét)
7.3
(206 Nhận xét)
6.6
(111 Nhận xét)
6.4
(81 Nhận xét)
6.1
(31 Nhận xét)
5.8
(46 Nhận xét)
5.3
(112 Nhận xét)
5.2
rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Thêm

$25 USD trong 1 ngày
(19 Nhận xét)
3.9
edatawiz

Hi there - It looks like the file you attached needs cleanup too. Do you have more than 45,000 rows in each of the 12 raw files ? Its more easy to consolidate separately all raw files and files with email and then do Thêm

$25 USD trong 1 ngày
(16 Nhận xét)
3.9
aldobraida98

Hi, hope you're doing well! My name is Aldo. I am an advanced actuarial student. I have great knowledge of working with: R, Python, SQL, VBA, Excel, finances and statistics. I always deliver high quality projects with Thêm

$20 USD trong 1 ngày
(17 Nhận xét)
3.9
akibul18

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

$18 USD trong 1 ngày
(2 Nhận xét)
2.5
umairnoor32

Hello! I am expert and professional in this work, I have read all your details and I will work on your project with low price and unlimited revisions. Give me this project and get extraordinary and 100% work. Thanks ? Thêm

$15 USD trong 1 ngày
(7 Nhận xét)
2.3
nawazacca

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

$18 USD trong 1 ngày
(3 Nhận xét)
1.8
Syedzaidi213

Hi, Greetings I Have Read Your Project Brief And I Understand That Your Of Entering The Right Email From File b To File A In Relevant Company Name Row. I Want To Ask That How Many Company Names In 1 Excel File ? I Can Thêm

$15 USD trong 7 ngày
(1 Nhận xét)
1.4
AhDardear

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

$15 USD trong 7 ngày
(1 Nhận xét)
1.4
hungng945

Hi I've read the project description carefully. I'm an expert in Excel VBA. Hope you contact me to discuss project more detail. Best regards!

$50 USD trong 1 ngày
(1 Nhận xét)
1.0
vw1514518vw

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

$15 USD trong 1 ngày
(1 Nhận xét)
0.8
wilfrednjorog

Hello! I am professional writer with the vast skills and qualifications necessary for this job. I have experience in Excel Macros, Google Spreadsheets, Excel, Excel VBA and Data Management. I am confident that I can Thêm

$30 USD trong 1 ngày
(0 Nhận xét)
0.0
DataHunter1

Hi, I hope that you are well. I have read your posted job and understood it. I Can do this job according to the requirements. I am an experienced data entry expert and virtual assistant providing services ranging Thêm

$15 USD trong 2 ngày
(0 Nhận xét)
0.0