Check out and return - Check if entered item is already checked out

Hello. I am not super experienced with Excel coding. I am currently working on a check out and return Excel document. I am having trouble when doing the return. So only the C and D columns will have the ability to be edited. When a value is entered in C, the other columns will generate. I want that if a value is entered in C and it is Checked Out already that it would change the cell in column G to have the return date and then delete the cell in C that was just entered. Here are some images to explain.

VHH9oIz.png

qyLSxlF.png

wMdIY3w.png

Here is the current code that I have for the worksheet. The code I am working on is between the "Work In Progress" comments.

Please Login or Register  to view this content.

Originally Posted by Maudibe

Try incorporating the following code into yours.

HTH,
Maud

Please Login or Register  to view this content.

That only checks if the item above is the same item. I would need it to scan the entire column to see if the item is checked out. On the right track though!