Hi,
I have a code that would already select the first D or N depending on what shift it is at work.
I would like a code that can then find the last cell value that matches the activecell value in column B but searches from the activecell downwards.
Example:
D
N
D
N - This is the activecell
N
N
N - I would like a code that would select this row in column B instead.
D
N
D
Any help would be appreciated.
Thanks
Dan
I have a code that would already select the first D or N depending on what shift it is at work.
I would like a code that can then find the last cell value that matches the activecell value in column B but searches from the activecell downwards.
Example:
D
N
D
N - This is the activecell
N
N
N - I would like a code that would select this row in column B instead.
D
N
D
Any help would be appreciated.
Thanks
Dan