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 visual basic applications excel, 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, excel 2013 visual basic applications, written file excel, excel 2013 visual basic, applications excel, macro calculate, visual basic applications 2013, macro formulas, spread macro excel, visual basic applications excel 2013, excel activities, raw data macro, excel raw data

Tietoa työnantajasta:
( 1 arvostelu ) The Woodlands, United States

Projektin tunnus: #4245049

Myönnetty käyttäjälle:


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)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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)

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)

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)