PDA

View Full Version : VBA for AUDITING



megha
03-01-2018, 12:32 PM
We have schedule in excelfile I want to make the auiting process autometically using macro o look for followings:



Any missed/open shift
Night to Day shift (meaning someone has not been schedued for Night Shift today and Day shift tomorrow)
Highlight with different color when someone is scheduled for more than 7 days
Highlight wth diferent color when someone is scheduled for 4 nights


Attached file is the sample. How do i start on this?

Thank you in advance!

SamT
03-01-2018, 01:35 PM
How do i start on this?

Rewrite the schedule and restructure the worksheet so that even us idiot Programmers can understand it.

Also, as written you can't compare one week's ending shift against the next week's starting shift (S=N + S=D)