Create excel macro to re-organize data - repost

Completado Publicado Feb 23, 2013 Pagado a la entrega
Completado 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: #4274124

Sobre el proyecto

5 propuestas Proyecto remoto Activo Feb 23, 2013

Adjudicado a:

seaanddream

Hi, revise my bid...Read your PM pls.. KR

$35 USD en 3 días
(13 comentarios)
3.6

5 freelancers están ofertando un promedio de $57 por este trabajo

mrbrave

VBA expert here..I have looked at both sheets and have understood requirements....Lets start now and get it done in 3 hours guaranteed..

$60 USD en 1 día
(67 comentarios)
5.3
pierreho

coolraz, comme je te l'ai dit je peux réalise ce traitement. A bientôt j'espère. Pierre

$100 USD en 2 días
(23 comentarios)
4.8
rengrish

Hi Excel Expert Here . I have 10+ years of experience in excel. Ready to take up immediately.

$40 USD en 1 día
(26 comentarios)
4.3
mobidv

I have over 10 years experience using excel and could have this completed quickly and professionally. Let me know if you have any questions for me.

$50 USD en 3 días
(0 comentarios)
0.0