Clear cell contents based on offset of dropdown selection on another tab.

Ive got this code, which moves the offset of a selection from a cells drop downlist to another tab:

Please Login or Register  to view this content.

But I can't figure out how to do the opposite - CLEAR the cell on the Last Planner tab if it matches the offset value of the selected cells dropdown list. Instead of "Moved to last planner" the cell choice that would activate the removal would be "Not Implemented". Somehow I need to compare the offset value from one tab to the range of values in a column in another tab - if it finds it, it clears it.

You may need to post a sample workbook demonstrating the values being "searched" for. You will again use the .Find() method, but this time it will need to search for a specific value in a specific column.

Concept - declare a vFIND range variable. Use the .Find method to try and fill that variable by specific search. If the variable is filled, then you have an anchor cell you can now use to send other command to cells on that same row as the vFIND. If the variable is not filled, then it wasn't found and nothing happens.

For example:

Please Login or Register  to view this content.