Automate split data into separate excel sheets

CLOSED
Bids
18
Avg Bid (INR)
883 / hr
Project Budget (INR)
₹750 - ₹1250 / hr

Project Description:
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

Hours of work: 5 Project Duration: 1 - 4 Wochen Skills required:
Database Administration, Excel, Microsoft Access, Software Testing, SQL
Hire MukeshVashisth
Project posted by:
MukeshVashisth India
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


₹1000 / hr
Hours: 5 hr/ week
₹750 / hr
Hours: 5 hr/ week
₹750 / hr
Hours: 3 hr/ week
₹750 / hr
Hours: 5 hr/ week
₹750 / hr
Hours: 5 hr/ week
₹1250 / hr
Hours: 168 hr/ week
₹800 / hr
Hours: 5 hr/ week
Hire excel3699
₹750 / hr
Hours: 5 hr/ week
Hire dmagrawal19
₹900 / hr
Hours: 5 hr/ week
Hire V4Value
₹800 / hr
Hours: 15 hr/ week