|We need more details.|
Where are these characters? How did they get there?
When do you want the new sheet created? As soon as the Y or Yes is entered in a cell or as a column is scanned by the macro or something totally different?
Like I said, we need more details related to what you are trying to do.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.