En cours

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.

Compétences : Microsoft, Visual Basic

Voir plus : 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

Concernant l'employeur :
( 3 commentaires ) Sacramento, United States

N° du projet : #1057675

Décerné à :

ExcelVBAVeteran

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 en 0 jours
(1 Commentaire)
1.0

9 freelance ont fait une offre moyenne de 34 $ pour ce travail

koolsidz

Please see PMB

35 $ USD en 0 jours
(42 Commentaires)
5.1
northwolves

See PMB please

35 $ USD en 0 jours
(29 Commentaires)
4.5
ExcelGurus

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

35 $ USD en 0 jours
(3 Commentaires)
4.4
nasiruiu

I can do it successfully

33 $ USD en 1 jour
(0 Commentaires)
0.0
raystudio

It is easy and I can finish it for you.

30 $ USD en 1 jour
(0 Commentaires)
0.0
grishkatz

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

30 $ USD en 1 jour
(0 Commentaires)
0.0
nusratbd

Hi, Please check PMB.

50 $ USD en 5 jours
(0 Commentaires)
0.0
mrduke

Please see your PM

30 $ USD en 1 jour
(0 Commentaires)
1.4