Pointing out cells based on critiria

Hello to all. Not quite sure how to go about this. Looking for some help and grateful for any assistance. I am looking to have a macro perform a check. I have data in column K8:K600. I would like to look at each cell in this column and if the result of a previous cell is different than the next, I would like the macro to do the following: If previous cell is 1 and current cell is 0, take name in same row column B and ask if that name is UNAVAIL. If previous cell is 0 and current cell is 1, then ask if the name in same row column B is AVAIL.
If the answer is YES, then continue checking rest of cells in column K. If answer is NO, than stop and post message to fix entry. I know that I am asking for alot, but I am truly grateful for any help that might be given.
Thank you.

The next code may do what you need:

The macro compare each row with the next row; if in current row, column 'k' there is '1' and in next row, columns 'k' there is '0' then macro see the value of next row, column 'B'; if the value is 'UNAVAIL' then a prompt ask if continue check and if the answer is no then select the next row, column B and stop the check.

Please Login or Register  to view this content.

I hope it can help you.

Regards,
Antonio

Thank you for the response. You have helped me immensely. I appreciate the time

Glad to know it helped you to fix your problem.

Have a nice time.

Regards,
Antonio