Automation process - using Excel VBA & Macros for Data Transformation

Completed Posted last week Paid on delivery
Completed Paid on delivery

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files.

Key Tasks:

- Importing data from one Excel file

- Creating three files using VBA and Macros

- Data cleaning

- Data merging

- Data filtering

The data filtering will involve:

- Applying numerical ranges

- Text matching

- Date ranges

Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

Excel Visual Basic Visual Basic for Apps Data Processing Data Entry

Project ID: #39025583

About the project

15 proposals Remote project Active last week

Awarded to:

(226 Reviews)
7.0

15 freelancers are bidding on average ₹7133 for this job

habib1433

Hello, I am a senior Excel VBA specialist. Feel free to message me. I will write a macro for you to automate your workflow to transform data from a single Excel file into three separate files. Best Regards, -Habib

₹2000 INR in 1 day
(28 Reviews)
4.7
agupta2812

Hello there, Good day! I am highly interested in this project. I have relevant experience in Excel, PowerPoint, create automatic calculation software on excel powered with VBA macros, Data Extraction. Do let me kno More

₹12500 INR in 7 days
(8 Reviews)
3.3
jlrbcel

Hello over there!, If you are not a fake account, I'll help you with these requirements, see my profile for the extensive experience you can take advantage of. Let me know then, Jose Luis

₹7000 INR in 7 days
(11 Reviews)
3.1
freelancer96500

Hi, I checked your requirement, I can work on it. I have Experience in below technical work. 1. Power Bi Desktop & Services With DAX, Power Editor 2. Excel VBA, 3. Power Query, Power Pivot 4. Advance Excel, 5. Exc More

₹6000 INR in 7 days
(4 Reviews)
2.7
kaly25

Hello, I am excited to apply for your project, as it aligns perfectly with my expertise in VBA/Macro. With 9 years of experience in manufacturing/stock maaket trading, I can deliver high-quality results that meet your More

₹10000 INR in 3 days
(1 Review)
2.6
sidramuzahir

I am excited to apply for the Excel Developer position. With extensive experience in VBA and Macros, I have successfully automated workflows involving data transformation, cleaning, merging, and filtering. My expertise More

₹7000 INR in 7 days
(3 Reviews)
1.9
rajuk742

computer skills- one year ADCA ( Advanced Diploma in Computer Application) and Tally Prime Course. work Experience- two- year computer teaching experience. one- year Data entry and Billing experience Good Knowledge of More

₹7000 INR in 7 days
(0 Reviews)
0.0
ranjeetk83205

A good introduction can help you get clients as a freelancer! Let’s look at how we can write a successful introduction for freelancers.

₹7000 INR in 7 days
(0 Reviews)
0.0
roya3n

"Just trust me! I can complete your project even earlier than your deadline because it’s really easy for me. All you need to do is contact me. If I don’t deliver exactly what you’re looking for, you don’t have to pay m More

₹7000 INR in 5 days
(0 Reviews)
0.0
LymieJ

Hello Sir/Madam I’d love to assist with automating your workflow in Excel using VBA and Macros. With extensive experience in Excel development, I specialize in creating efficient solutions for data transformation and More

₹10000 INR in 7 days
(0 Reviews)
0.0
Yaqoub99

Hi, I hope this will find you helpful. I'm an excel expert, having very good commond in excel VBA, power query, power pivot, advance formula and function. I can create an automatic workflow for your task, using vba, o More

₹1500 INR in 2 days
(0 Reviews)
0.0