Käynnissä

Excel Macro - Spread OT hours

I need to have an excel macro written to distribute overtime hours as a weighted average across a number of activities.

The excel file is generated from a time keeping program. Each employee can have a different numbers of activities.

I have the formulas to calculate the time. I need help creating a macro to automate the process to run for all of the employees in the spreadsheet.

An example spreadsheet is attached. The first tab has the raw data as it is exported from the program. The second tab has the hours spread with the formulas that we have worked out.

Taidot: Excel, Visual Basic for Apps

Näytä lisää: need help excel, spread, excel formulas, excel automate, 2013 excel visual basic, excel macro program, raw excel data, excel 2013 visual, excel 2013 macro, macro spreadsheet, excel spreadsheet hours worked, visual basic excel 2013, written file excel, excel 2013 visual basic, applications excel, macro calculate, visual basic applications 2013, macro formulas, spread macro excel, excel activities, raw data macro, excel raw data, raw data excel, excel macro run, spreadsheet hours worked

About the Employer:
( 1 review ) The Woodlands, United States

Projektin tunnus: #4245049

Myönnetty käyttäjälle:

amcsummers

Welcome to Freelancer! There are a lot of good coders out there. Freelancer asks everyone to review the people they work with after every project. This will give you some insight on what to expect from the person yo Lisää

40 $ USD 1 päivässä
(38 arvostelua)
5.2

4 freelanceria on tarjonnut keskimäärin 33 $ tähän työhön

best4best

I can provide an easy-to-use template to calculate the average as specified in the example spreadsheet in 1-2 hours.

30 $ USD 0 päivässä
(64 arvostelua)
5.1
mandeeps207

Hi there, I m ready to finish this task right now. High quality work will be given....

30 $ USD 1 päivässä
(30 arvostelua)
4.4
bubu77

Hi, Ms Excel expert having 8+ yrs of IT experiance. Please see your PM for more details.

30 $ USD 2 päivässä
(1 arvostelu)
2.0