|I have no clue what you are trying to do.|
What do you mean by "Want to assign values to columns in Excel"? What values? What columns?
Where are these Y's and N's you are talking about?
Please click on the blue line at the bottom of this post and read the instructions found via that link. Then post some example data so we can see what you are talking about.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.