a1 a2 a3
last name first name tent
king joe mn
miller john n2
so what i want to do is if a name has n2 to go to a work sheet if it has mn to go to a different worksheet there will be other 2 code that will be next to names
this is in excel
i can send work sheets if that will help
yes you can post the workbook on www.wikisend.com and post the download url in here so I can look at it.
not sure what you mean by go to another worksheet. do you want it to pull information from the other worksheet or do something else ?
are you looking for a formula or a macro ?
so uploaded the sheet http://www.wikisend.com/download/442446/
on sheet 1 there is a list of names last name first name next to there name is XXXXX XXXXX under tent n2 would show up on sheet 2 anything with n1 would show up on sheet 2 sheet 1 and 2 name will change
what do you mean "show up on"
I got the sheet but I am at a loss for what you want it to do
what is the entire sheet for ? what is your actual goal here ?
on sheet 1 you see the list of names last first c9-c9 then e9 is a 2 letters and number say i sort by column e so so then i want all names that have n2 in the e column to go to sheet 2
what more do you need from me