Erase Value in Adjacent Cell

Thank you for looking at my problem. This is actually a continuation of a previous post.

Attached is a file with two worksheets that is part of a much larger spreadsheet for a charity event. Each of the worksheets contains a list of names. When you click on the "Data Entry" button on the Info worksheet, a userform will come up. Using that userform, when I erase a name on the "Info" worksheet using the "Delete" button, I would like to also erase that name on the other sheet (not delete the entire row).

I was given the following code by sintek that works great:

Please Login or Register  to view this content.

The additional question is how do I also erase the value in the cell to the right of the name only on the "Info" worksheet (in the "Index" column)? I should have included that question in my previous post. I am a beginner and cannot come up with a solution. Thank you again.

I think this should do what you're asking for.

Please Login or Register  to view this content.

Excellent! Works great. Thank you for another learning experience.

Originally Posted by YasserKhalil

Hello Dan
If you intend to deal with just the sheet "Inf" .. Why didn't you exclude the sheet after the line of loop directly in that way

Please Login or Register  to view this content.

I think this will save some time as the code will skip the lines of Find which may take some time with larger data

Hi Yasser,
My understanding was that the code for finding/erasing the name was to be used on all sheets, and erasing the value beside the name was to be done on the info sheet only. That's why I structured it this way - otherwise yes, your method would save time.