Not sure this is possible, but it is way beyond my understanding so any support will be very appreciated.
Attached is a simplified file that I am working on.
On Sheet 1 it states the job numbers and rota's for that week (week 1). There is another sheet that show the knowledge of the relief persons.
Is it possible that a macro can be set up that automatically populates the relief cells on week 1 sheet using the information provided on job knowledge sheet.
Thank you for any support offered
Last edited by ujpest; 05-04-2012 at 07:39 AM.
Do you have a sample output file that you can upload? Your request is not very clear.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Sorry for my poor clarity.
Basically what I am after is when I click a Macro for Monday (for example) to auto assign the relief persons to a job that is not covered.
With the attachment above on Monday job 203 and 204 is not covered. I would run the macro and using the information from the Job Knowledge tab, Sue would be allocated job 204 and Helen 203
Thank you
How do we know which jobs are not covered?
Hi Arlette,
I have a macro that highlights through a message box which jobs are not covered.
Thank you
Please Login or Register to view this content.
Last edited by ujpest; 05-14-2012 at 03:11 PM. Reason: needed to code tags on my post
So this new piece of code you require should take the values from the msgbox and proceed further?
Yes if possible please.
Thank you
Ian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks