Automate split data into separate excel sheets

Completado Publicado Dec 2, 2012 Pagado a la entrega
Completado Pagado a la entrega

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

Programación en C Excel Microsoft Access SAS SQL

Nº del proyecto: #4003832

Sobre el proyecto

31 propuestas Proyecto remoto Activo Dec 3, 2012

Adjudicado a:

cnsolutionsvw

Hi, I have 25 years of experience working with spreadsheets. I've also worked as a data expert for Microsoft so this shouldn't be a problem.

$30 AUD en 1 día
(1 comentario)
1.4

31 freelancers están ofertando un promedio de $73 por este trabajo

Teloquence

Consider it done. Check your PM for my bid details.

$100 AUD en 0 días
(325 comentarios)
7.6
deepbluetech

I can take on the job and complete it within 24 hours. Let me know.

$150 AUD en 1 día
(181 comentarios)
7.3
bouslimi1979

Please check PM. Thanks

$50 AUD en 1 día
(220 comentarios)
7.4
sy3d

Consider it done with 100% accuracy, highly professional here ...ready to provide you sample before we move ahead... check your pm, thx

$66 AUD en 1 día
(282 comentarios)
7.2
greggfletcher

Hello, I have expertise in excel/VBA. If interested in my bid, please contact me, so we can discuss the details. Best Regards.

$100 AUD en 1 día
(44 comentarios)
6.6
rohitagarberg

Sir, Please send us the file and the directions. We will make the application. We have 100% completion rate. Thanks

$30 AUD en 1 día
(272 comentarios)
6.2
pakee

Consider it done. IT professional here. check your pm for further.. thanx

$59 AUD en 1 día
(110 comentarios)
6.3
nagybatonyi

Such jobs are my daily practice. I can complete the job in some hours. My bid includes the macro doing the job if you need it for further use. Further use of macros, fixing of bugs and minor changes are included in the Más

$80 AUD en 1 día
(62 comentarios)
5.7
gshiels

Please see PM

$250 AUD en 1 día
(11 comentarios)
5.2
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$98 AUD en 2 días
(48 comentarios)
5.7
diegogarcia0531

Hi, I can do the job, MS Excel expert, VBA, VB6, VBNET developer for a several years, macro expert Regards Diego

$35 AUD en 1 día
(39 comentarios)
5.5
bob1982

if you need it in one day then i think i am the best one to do this i have good experience in dealing with large data in excel vba thanks

$200 AUD en 1 día
(60 comentarios)
4.9
ammarasaeed

Hello sir i am ready to start without money....Please check PMB

$30 AUD en 1 día
(13 comentarios)
4.4
adim

Top 1% in VB6 on Freelancer and lot of experience in this field, please check PM.

$65 AUD en 1 día
(9 comentarios)
4.1
vikashgadia

we r excel macro expert from India. We have over 13 years of excel macro programming experience and can do any thing and everything in excel.

$65 AUD en 2 días
(15 comentarios)
3.8
EgyProgramer

Hi, Kindly check Inbox. Ready to do it now

$30 AUD en 0 días
(9 comentarios)
3.3
developer287

expert vba & vb.net here. i can start now.

$30 AUD en 1 día
(6 comentarios)
3.1
bssMSOfficeMVP

I can do this for you in one day. I've worked several projects like this recently and have the code ready now. It should only need some minor tweaks to work with your data as described. I have years of experience wo Más

$30 AUD en 1 día
(3 comentarios)
2.5
logoDS761

Consider my bid!

$200 AUD en 2 días
(2 comentarios)
2.0
moussa1

I can do that!

$30 AUD en 1 día
(2 comentarios)
2.1