Find Jobs
Hire Freelancers

Automate split data into separate excel sheets

₹750-1250 INR / hour

Closed
Posted over 11 years ago

₹750-1250 INR / hour

I have 3 sheets in excel 1) 1st sheet has 15 columns and about 60K rows. 2) 2nd sheet has 2-3 columns, 1K rows 3) 3rd sheet as 2-3 columns, 500 rows There is a common ID across all three sheets Using the data in the above tables.. I need someone to split the data in the tables into multiple excel workbooks and multiple sheets so that for every "common ID" it will have its own workbook with three sheets. and the data in those three sheets will only include data relevant to the "common ID". You will need to export the data into a template workbook i have prepared and you will need to follow the order of the columns provided in the template.. (I have formulas and pivot tables running off the template so you will need to ensure that I can continue to use the template in the various workbooks you have created for me) I also need the output workbooks to have the naming convention for example - "common ID" - "[table1] [field3]".xlsm Serious bidders only.. you will be expected to turn this around in 1 day Thanks
Project ID: 4006008

About the project

16 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₹856 INR/hour for this job
User Avatar
Hi please see PMB
₹1,000 INR in 5 days
4.5 (52 reviews)
6.0
6.0
User Avatar
I can do it quickly.
₹750 INR in 5 days
4.9 (30 reviews)
5.4
5.4
User Avatar
Hello, I am a serious bidder. but no one is taking that way. You accept me today -> you will get code tomorrow sharp. just send the template I will make sure nothing changes but the data is filled. please see my msg in your pmb. Regards, Karim
₹750 INR in 3 days
4.8 (6 reviews)
3.1
3.1
User Avatar
Greetings Client, I will be able to help you with your project request. I will provide you with a very robust and accurate project output. I have over 7 years of experience in Excel,Access VBA. I have developed and managed database and automated reports for different projects. Regards Mukul
₹750 INR in 5 days
5.0 (2 reviews)
2.2
2.2
User Avatar
I can develop a small utility or even can write VBA script in excel to perform the task. I can finish task in 3-5 hrs.
₹750 INR in 5 days
4.8 (1 review)
1.8
1.8
User Avatar
I'm interested.
₹1,250 INR in 168 days
5.0 (2 reviews)
0.4
0.4
User Avatar
Respected Sir/Madam, My self Dhaval Vachhani working as a networking engineer in various establishments and i am going to plan a work of data entry and i like to join you for that i surely give you quality work and eager for your positive reply. Your Faithfully, Dhaval Vachhani
₹750 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please send me the file so we can start working on the project.
₹750 INR in 5 days
0.0 (0 reviews)
2.2
2.2
User Avatar
This project will be delivered before or on time if given the chance. My bid is in place
₹750 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, This work for me. I am skilled in the data processing in Excel and in Access. I'd be happy to help you. Thanks
₹750 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will create an Access database (rdbms) and import your three sheets into it. I then will generate queries to export data to give you new sheets with unique names. I may also create UI for you to enter new data or create a utility to upload/import new data. Sounds good? Let me help you.
₹1,200 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>
₹1,000 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have good excel skills and recently I have made a very similar project. Please provide the files and you get the result in a short time. Kind regards.
₹750 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would be able to do this. I have good experience in excel exporting.
₹800 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi.. We are a team of Excel/VBA experts working for a MNC. We have worked on a similar issue with an Energy client. I think we can offer you a solution here in a limited time frame. Let us know what you think. Thanks.
₹800 INR in 15 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been involved in exactly this kind of work. Copying the datas from one sheet to another sheet/workbook. Please do select me for error free and perfect result. You will be delihgted!! Thanks!!
₹900 INR in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Dec 3, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.