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

Skills: Data Entry, Data Processing, Excel

See more: 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

Project ID: #4274103

16 freelancers are bidding on average $73 for this job


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

$75 USD in 2 days
(59 Reviews)

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 in 2 days
(40 Reviews)

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 in 3 days
(23 Reviews)

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

$100 USD in 2 days
(24 Reviews)

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

$80 USD in 1 day
(33 Reviews)

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 More

$40 USD in 1 day
(8 Reviews)

More than 10 years experience in Excel and VBA.

$70 USD in 1 day
(5 Reviews)

Please check your PM..!!

$40 USD in 2 days
(6 Reviews)

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

$60 USD in 2 days
(1 Review)

Excel/VBA expert here. Please check PM.

$99 USD in 4 days
(2 Reviews)

I would like to do this project for you.

$30 USD in 14 days
(2 Reviews)

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

$40 USD in 1 day
(4 Reviews)

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

$40 USD in 0 days
(3 Reviews)

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 in 1 day
(1 Review)

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

$30 USD in 3 days
(0 Reviews)

I can do it for you

$250 USD in 7 days
(0 Reviews)