Macro Project:Need Help

[girish.shr1]

I am a very novice to Macros however somehow landed into making
project in office.

In a simple usecase it is explained as follow

1.There exists 5 persons A,B,C,D,E

2. Each do 4 different work
eg A does A1,A2,A3,A4
B does B1,B2,B3,B4
......

3.We need to track the work done by each person date wise.

eg on Feb1 A does A1,A2,A3,A4

4.If on a particular day one person is absent -then the work needs t
be reassigned to other 4 in round robin.

5.So We need to track the absence and assign the work to the othe
workers present

6.All this needs to be done on a click of button


I dont know where to start and how to proceed

Please help!!!

 

[Rod Gill]

Hi,

The project.developer group is best for VBA questions. However, before even
starting to program, you need to look at the process your users need to
follow, then detail exactly what the macro has to do (remember the computer
has zero intelligence) then start to code.

I would start by developing your process to the stage where anyone can
follow a precise set of instructions to do the work manually, then start
coding the most labour intensive parts first.

Good Luck!

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com