Hi, I need to vba code for the following:
I have a spreadsheet with names in cells C16:I43 what I need to do is if a the same name appears in row C & D highlight those cells with the same name and then do this for rows D & E, then E & F, then F & G and so on.
The way my spreadsheet is layed out is row C & D is day one row E & F is day two row G & H is day three and so on, then row C would be day work and row D night, row E day work and row F night work and so on.
What I'm trying to do is make sure that the same person is not scheduled for day work on day one and then scheduled for night work on day one, or for night work on day one and day work on day two, etc.
Hope this makes sense.
Thanks
Rick
I have a spreadsheet with names in cells C16:I43 what I need to do is if a the same name appears in row C & D highlight those cells with the same name and then do this for rows D & E, then E & F, then F & G and so on.
The way my spreadsheet is layed out is row C & D is day one row E & F is day two row G & H is day three and so on, then row C would be day work and row D night, row E day work and row F night work and so on.
What I'm trying to do is make sure that the same person is not scheduled for day work on day one and then scheduled for night work on day one, or for night work on day one and day work on day two, etc.
Hope this makes sense.
Thanks
Rick