Peruttu

Create excel macro to re-organize data

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ää: create macro organize data, excel macro taking sheet info putting sheet, excel macro organize data, 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

Tietoa työnantajasta:
( 7 arvostelua ) Vancouver, United States

Projektin tunnus: #4274103

16 freelancers are bidding on average $73 for this job

sonarkaushik

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

75 $ USD 2 päivässä
(59 arvostelua)
5.7
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 2 päivässä
(40 arvostelua)
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 3 päivässä
(23 arvostelua)
4.9
pierreho

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

100 $ USD 2 päivässä
(24 arvostelua)
4.8
slavisatosic

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

80 $ USD 1 päivässä
(33 arvostelua)
4.7
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 Lisää

40 $ USD 1 päivässä
(8 arvostelua)
3.5
adim

More than 10 years experience in Excel and VBA.

70 $ USD 1 päivässä
(5 arvostelua)
3.3
jaylancer43

Please check your PM..!!

40 $ USD 2 päivässä
(6 arvostelua)
2.9
HosElectro

experience programmer i can do the work for you ready to start right away

60 $ USD 2 päivässä
(1 arvostelu)
2.3
bharat1010

Excel/VBA expert here. Please check PM.

99 $ USD 4 päivässä
(2 arvostelua)
2.2
epdailo

I would like to do this project for you.

30 $ USD 14 päivässä
(2 arvostelua)
2.2
Abikris

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

40 $ USD 1 päivässä
(4 arvostelua)
2.1
phpthebest

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

40 $ USD 0 päivässä
(3 arvostelua)
2.0
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 1 päivässä
(1 arvostelu)
1.3
paris2785

I can do it for you

250 $ USD 7 päivässä
(0 arvostelua)
0.0
WorkingSmart115

I work with VBA almost every day. I look forward to delivering a satisfactory project & gaining more experience with Freelancer.

30 $ USD 3 päivässä
(0 arvostelua)
1.0