Đã hoàn thành

Data Mapping Using VBA

Hi,

I want to merge data from 2 files. You have to consider a few parameters and based on that you have to copy the data from one file to another file. there is 1 big file for Old Hotels and 3 big files for New hotel you will search for a hotel name from the old file to a new hotel file. If the name match, then you will search for the city name from old file to new file and if the city also matches, you will copy the entire row for that hotel and copy it in the new hotel's file in the same row for which hotel name and city name match.

there are around 400k records in the old file and 1.4 M records in the new hotel's file. I can send one sample file and I need macro so I can do it by myself.

is this something you can do?

Kĩ năng: Excel, Nhập liệu, Visual Basic, Xử lí dữ liệu, Visual Basic cho Ứng dụng

Xem nhiều hơn: what do you use to automate data analysis in excel, vba automation projects, excel report using vba, excel vba mapping table, vba for business, vba analysis, data analysis using vba, vba automation, data mapping oracle using informatica, data excel workbook master workbook using vba, using excel data google finance vba, export data webpage excel sheet using vba, import mpp data excel using macro, extract data email message body using vba, extract data file using vba, import project data excel using vba, copy internet explorer data excel using vba, data extraction using vba, transfer data excel word using vba, export excel data project using macro

Về Bên Thuê:
( 1 Nhận xét ) surat, India

ID dự án: #20618365

Được trao cho:

srikartiram

Hello, I can do the Macro for Rs.3000/- but if you want just this 2 files matched you dont have to us macro this can be obtained using formulas itself. I will do this one time matching job for Rs.1500/- and will also Thêm

₹1000 INR trong 5 ngày
(189 Đánh Giá)
6.5

20 freelancer đang chào giá trung bình ₹2402 cho công việc này

citijayamala

1. I am an expert in Excel,VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projec Thêm

₹9000 INR trong 3 ngày
(65 Nhận xét)
5.6
vsprybhanu

Hi, I have done similar job which is almost same. Please watch this video - [login to view URL] I am experienced Data Analyst and Macro Developer and have done mostly Ex Thêm

₹2500 INR trong 3 ngày
(91 Nhận xét)
5.7
GopalJp

This is Gopal.I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverables. I am a professional accountant Thêm

₹4000 INR trong 2 ngày
(13 Nhận xét)
4.4
kankshi619

Hello Sir, I am willing to work on the task and can handle it efficiently as desired by you without any errors.

₹1500 INR trong 7 ngày
(15 Nhận xét)
3.7
mowachira77

Hi there. I am available to start your work now and deliver it in 5 hours. The deliverables are completed matched files and VBA script so that you can do it your self. I have vast experience in excel and VBA and it wou Thêm

₹1050 INR trong 1 ngày
(8 Nhận xét)
3.2
mattjparker1104

⭐ Dear, Client ⭐ Nice to have you. I have read your description carefully and I understand the goal. I have rich experience in excel & web scrapping & data processing & data entry. I'm really VBA macro expert. Please t Thêm

₹1000 INR trong 1 ngày
(5 Nhận xét)
1.6
EDSRD

Hi, We have been working on excel macros since many years now. We would be happy to help you get the work done for you. We have gone through the description. If you can share the file we can start quickly. Thank you.

₹1500 INR trong 2 ngày
(1 Nhận xét)
0.6
mehedimunna928

Hi, We have been working on excel macros since many years now. We would be happy to help you get the work done for you. We have gone through the description. If you can share the file we can start quickly. Thank you.

₹1050 INR trong 10 ngày
(0 Nhận xét)
0.0
digvijaygujale

Hi , I gone through your description. your data is huge and it's quite impossible to copy from 1 file to another using Macro(VBA) it may crash the excle file. If you allow me to work on this project i will use another Thêm

₹1250 INR trong 2 ngày
(0 Nhận xét)
0.0
GKTransformation

Hi, I have around 4years of experience in developing automation tools using Excel VBA. I will provide you end to end solution for the same and will be delivered with in time without any reasons. Thank You! Regards, G Thêm

₹1249 INR trong 3 ngày
(0 Nhận xét)
0.0
tausif834

I'm interested in your project. your project is like data mining which will I complete it within given time.

₹13333 INR trong 10 ngày
(0 Nhận xét)
0.0
₹1300 INR trong 1 ngày
(0 Nhận xét)
0.0
Taney2903

My work is my life Relevant Skills and Experience Data entry

₹1300 INR trong 1 ngày
(0 Nhận xét)
0.0
prabhudas281998

I am a self-motivated person who is willing to go above and beyond on any project, and to learn valuable skills on my own time. For example, I taught myself five computer programming languages in college, simply out of Thêm

₹1050 INR trong 3 ngày
(0 Nhận xét)
0.0
sirajshah05

sir kindly provide me this work i can do is ass per your need i am expert on excel and word projects i an glad if you handover me this [login to view URL] u sir

₹1200 INR trong 7 ngày
(0 Nhận xét)
0.0
ujjwalrai999

Hi, I am Ujjwal Rai. I am 28 years old and completed masters in public administration. I have worked as a data entry personnel, enumerator, and data analysis in much non-governmental organization working majorly in the Thêm

₹900 INR trong 7 ngày
(0 Nhận xét)
0.0
₹1300 INR trong 3 ngày
(0 Nhận xét)
0.0
ParthKantariya

I have good typing skills and have good knowledge in data entry, microsoft office ie. word, excel, Ppt etc.. and internet search & data Analysis. I will surely meet above your expectation.I assure top Quality Work and Thêm

₹1050 INR trong 7 ngày
(0 Nhận xét)
1.7
jaspreetgill8872

Hii I will my bast to do this work

₹1500 INR trong 7 ngày
(0 Nhận xét)
0.0