Käynnissä

Create excel macro to re-organize data - repost

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!!

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: what's data processing, what comes under data entry, data entry worksheet, data entry macro, data entry exercise, data entry device, ask excel, what is macro in excel, less than excel, excel less than, simple macro, macro e, excel-to-csv, Excel to CSV, Excel Formulas, create excel worksheet, create an excel, create 200, bidding formulas, please worksheet attached, excel macro csv, data entry worksheet excel, copy csv excel, excel 2013 macro, point excel

About the Employer:
( 7 reviews ) Vancouver, United States

Projektin tunnus: #4274124

Myönnetty käyttäjälle:

seaanddream

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

35 $ USD 3 päivässä
(13 arvostelua)
3.6

5 freelanceria on tarjonnut keskimäärin 57 $ tähän työhön

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 1 päivässä
(67 arvostelua)
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 2 päivässä
(23 arvostelua)
4.8
rengrish

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

40 $ USD 1 päivässä
(26 arvostelua)
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 3 päivässä
(0 arvostelua)
0.0