ClearContents of all other Cells in Range if "Y" in List Box is selected

[WilliamL83]

Hi everyone

I am trying to create column B of the worksheet where the user can select "Y" in the list box. each cell of column B will give the user a choice to select "Y".
If Y is selected, then a range of cells in that respective Row gets copied over to another sheet.

The issue I am facing is this; I would like to clear any existing "Y" that might have previously been selected at the same time when the user making a new "Y" selection from the dropdown box.

Here is the code I currently have;

Please Login or Register  to view this content.

Any help will be much appreciated!

WilliamL

[xladept]

I'd change things around a bit and clear the "Y" after I'd processed it:

Please Login or Register  to view this content.