Automatically delete the same value in a cell when filled in other cell

Hi everybody!

Can somebody please help me with the next problem?
I'd like a code to automatically delete the value in column AK and its corespondent in AL, if the value in AK is filled in column C (see workbook attached!)

Many thanks!

Maybe:

Please Login or Register  to view this content.

Originally Posted by alansidman

I am looking at your spreadsheet and not understanding your logic. Please tell us your logic for deleting values in AK and AL and/or copying AK value to C. It is not clear to me.

Well,

In column C there are ID registration numbers within a range of numbers that have to be filled in by some users. If any of them doesn't fill in, I have a module that finds the missing numbers within that range and display them in column AK. Manually, I fill in column AL the name of the person who has to do the job. When the users make the registration that has an ID in the missing numbers column (AK), I'd like to automatically delete that ID and the name of the person in AL.

Not quite sure if I made myself clear

Yes. It should go in the Sheet Change Event Module. Right click on the sheet tab, choose worksheet, left side choose change. Code goes there.

Originally Posted by JOHN H. DAVIS

Yes. It should go in the Sheet Change Event Module. Right click on the sheet tab, choose worksheet, left side choose change. Code goes there.

I just realized that

Thank you so much again.

You're welcome. Glad to help out and thanks for the feedback.