Automate split data into separate excel sheets

Closed

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

Skills: Database Administration, Excel, Microsoft Access, Software Testing, SQL

See more: excel split data separate sheets xlsm, split excel sheet multiple sheets, split data multiple workbooks, excel split separate sheets, split data multiple sheets excel, excel split columns, split, sheets, pivot tables, order split, formulas sheets, excel pivot, Excel formulas, excel automate, template workbooks, excel split data sheets, excel split sheet sheets, separate excel data sheets, multiple excel, excel split sheet, excel split, excel export template, pivot tables automate, export excel data excel workbook, excel export data multiple sheets

About the Employer:
( 0 reviews ) India

Project ID: #4005536

21 freelancers are bidding on average ₹13095 for this job

slavisatosic

Hello, I am offering you to split your workbook in one day using Excel VBA.

₹12500 INR in 1 day
(112 Reviews)
6.0
pierreho

OK for me, is will be very quickly

₹12500 INR in 2 days
(27 Reviews)
5.2
datagrabbers

ready for the job

₹18000 INR in 1 day
(18 Reviews)
5.0
NiceDeveloper

Hi, I'll do it all with a win app which will give us desired result. Check your inbox for more details. Thanks

₹15000 INR in 4 days
(7 Reviews)
4.8
sumon355

Hello, I am interested to do this work.

₹13000 INR in 2 days
(24 Reviews)
3.3
swagatab

Hello, I assume the scope of this project is to split the current data and not to develop a system which will take care of this with other spreadsheets as well. Please confirm. If my understanding is correct, I will More

₹12500 INR in 3 days
(5 Reviews)
3.2
aapS0ftware

Hello, I have a Bachelor's degree in Computer Science and a Master's degree in Advanced Computer Architectures. I currently work as a senior software developer. I have been lot's of experience in software automation a More

₹12500 INR in 2 days
(1 Review)
1.4
nope0000

I do that with ETL Software

₹12500 INR in 4 days
(1 Review)
0.6
harikrishnansrin

I very well understood this project.please send me sample i will able to write a VBA code for you. I am sure i can complete this work less than 3 days. This is my skype id :QualityHari

₹12500 INR in 3 days
(0 Reviews)
0.0
dmagrawal19

This is a perfect job for me. I have always been doing this kind of work. Please do select me for error free and perfect result. Thanks!!

₹13000 INR in 5 days
(0 Reviews)
0.0
mrjackie

Never up never in

₹12500 INR in 7 days
(0 Reviews)
0.0
FoxproGuy

Hello I am an ETL programmer. data transformation is my forte.

₹12500 INR in 1 day
(0 Reviews)
0.0
imssai

Hi, I am an automation expert in excel. I have hands on experience of automating the excel files based on the various requirements. I will definitely meet your expectations and will complete the project within the s More

₹12500 INR in 1 day
(0 Reviews)
0.0
cosprogrammer

I have previous experience in projects of this type. I can guarantee you will be satisfied.

₹12500 INR in 1 day
(0 Reviews)
0.0
xlsvba

I can help you

₹12500 INR in 2 days
(0 Reviews)
0.0
vw6394448vw

Dear value customer, I'm an excel expert with more than 10 year experience. I offer you very good quality and good price.

₹12500 INR in 1 day
(0 Reviews)
0.0
petofsky

I can start that job immediatly. Pleas send me details.

₹12500 INR in 1 day
(0 Reviews)
0.0
sunny1626

Hi..can do it using VBA MACRO..in 1 day itself...

₹15000 INR in 1 day
(0 Reviews)
0.0
PETRA

Ready to start. Please send details.

₹13500 INR in 1 day
(0 Reviews)
0.0
hudhtml

i have a great experience work with VBA, macros and excel.

₹12500 INR in 1 day
(0 Reviews)
0.0