Create excel macro to re-organize data

Cancelado Publicado Feb 23, 2013 Pagado a la entrega
Cancelado Pagado a la entrega

I need you to create an excel macro.

The starting point is the worksheet I have attached. Keep in mind, right now the worksheet has 3 dates (with entries under each date). However, this macro needs to be able to use many dates (we will have 200+). Here is what we need:

1. The Macro needs to take the info under each date on Sheet #1 ("exportdata"), and organize it by WORKOUT (see Sheet #2 ("organizdata" on this worksheet).

2. Keep in mind, under each date there is a different number of workout (for example 1 date could have 10 exercise and another could have 20). Therefore, I could not use simple formulas to do this.

3. Under each workout, there MAY be more or less than 3 sets. So make sure that the macro puts all the sets in the Sheet #2 "organizedata"

4. It's important to know, that this info comes from a workout tracking device which exports to CSV file, therefore, with each new update, a NEW csv file is created, and I will be copy-pasting that data into this worksheet. So, make sure that it will work if I copy-paste new data on Sheet 1 (i.e the macro needs to be auto-updating).

5. Where I put in formulas, these just need to be converted to real formulas (remove the quotes) and intregrated into the macro so that when it's taking the data from Sheet 1 and putting into Sheet 2 it will automatically calculate those values.

If you have any questions, please ask before bidding. Thank you!!

Entrada de datos Procesamiento de datos Excel

Nº del proyecto: #4274103

Sobre el proyecto

14 propuestas Proyecto remoto Activo Feb 24, 2013

14 freelancers están ofertando un promedio de $77 por este trabajo

jaylancer43

Please check your PM..!!

$40 USD en 2 días
(815 comentarios)
8.8
paris2785

I can do it for you

$250 USD en 7 días
(334 comentarios)
7.9
sonarkaushik

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

$75 USD en 2 días
(102 comentarios)
6.3
nagybatonyi

If you send me a spreadsheet with sheet2 I'll create a free draft pilot for you. Please, see PMB for some other details! Regards

$90 USD en 2 días
(64 comentarios)
5.7
pierreho

Dear coolraz, your need seems to be easy. Looking foreward. Kind regards

$100 USD en 2 días
(30 comentarios)
5.4
MDavidCrompton

There is no second sheet on your excel file so I cannot produce a sample. If you send me required output I will send a sample. Please check my feedback.

$100 USD en 3 días
(35 comentarios)
5.2
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Also done a SAMPLE that will SOLVE your problem. Best reg Más

$40 USD en 1 día
(14 comentarios)
4.8
slavisatosic

Hello, I am offering you to make this macro by tomorrow. Please see private message for details.

$80 USD en 1 día
(19 comentarios)
4.4
bharat1010

Excel/VBA expert here. Please check PM.

$99 USD en 4 días
(7 comentarios)
3.8
adim

More than 10 years experience in Excel and VBA.

$70 USD en 1 día
(7 comentarios)
3.8
phpthebest

Hi, I can start now ,please check your message.

$40 USD en 0 días
(5 comentarios)
3.1
Abikris

Hi, I'm happy to help you. See PMB for details.

$40 USD en 1 día
(5 comentarios)
2.5
epdailo

I would like to do this project for you.

$30 USD en 14 días
(2 comentarios)
2.2
sokhom168

That is my daily task for my current company. You will get the result more than you expected. See my message for idea to make you even easier in this task than what you described.

$30 USD en 1 día
(1 comentario)
1.3