Đã hoàn thành

VBA Code Hours Allocation

Excel workbook has a worksheet that includes project information in a row of 5 adjacent cells (including a start date) and a table that has 6 job positions (vertical axis) and 8 weeks (horizontal axis). The body of the table has the hours for each position for each week. There are six additional worksheets, one for each job position. Project information and the related hours are in rows with the start dates across the top.

We need the VBA code to add to an existing macro to copy the project information to the next available row for each of the 6 job position worksheets and take the hours for the 8 weeks for each job position and copy the data to its own worksheet, also in the next available row and paste the data starting in the appropriate column that matches the start date in the project information.

In the attached Excel 2000 file, the data in B5 through F5 in the sheet 'Selection' would be copied to all six sheets starting with 'Bus Analyst' in B7 through F7 (the next available row) and the the hours for each position in the table (I13 through P18) would be copied (paste special) to the appropriate sheet starting at K7 (the next available row for the starting date of 6/3/2011).

If we have described this properly, we estimate the development time to be about one hour.

Kĩ năng: Microsoft, Visual Basic

Xem nhiều hơn: vba with, starting with visual basic, sheets add, job matches, hour of code, code top, code 8, vba code allocation, vba time, vba for, microsoft vba, microsoft macro, microsoft excel VBA, in vba, data analyst position, vba, vba excel, vba excel macro, vba code excel, VBA and excel, next hours, Macro vba, k7, hours, excel vba macro

Về Bên Thuê:
( 3 nhận xét ) Sacramento, United States

ID dự án: #1057675

Được trao cho:


Hi, lets get done with it today. I have over 3 years Excel VBA (macros, automation) experience, and can easily finish it in one day (if not one hour). So can send you by tonight (UK time). Thanks.

$30 USD trong 0 ngày
(1 Nhận xét)

9 freelancer đang chào giá trung bình $34 cho công việc này


Please see PMB

$35 USD trong 0 ngày
(42 Nhận xét)

See PMB please

$35 USD trong 0 ngày
(29 Nhận xét)

Hello, Please see your PMB for details. Thank you, David

$35 USD trong 0 ngày
(3 Nhận xét)

I can do it successfully

$33 USD trong 1 ngày
(0 Nhận xét)

It is easy and I can finish it for you.

$30 USD trong 1 ngày
(0 Nhận xét)

The project looks to be easy to complete, ready start working now.

$30 USD trong 1 ngày
(0 Nhận xét)

Hi, Please check PMB.

$50 USD trong 5 ngày
(0 Nhận xét)

Please see your PM

$30 USD trong 1 ngày
(0 Nhận xét)