How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

a1 a2 a3 last name first name

Customer Question

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

Submitted: 4 years ago.
Category: Microsoft Office
Expert:  flopcat98 replied 4 years ago.

yes you can post the workbook on 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 ?

Customer: replied 4 years ago.



so uploaded the sheet


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

Expert:  flopcat98 replied 4 years ago.

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 ?

Customer: replied 4 years ago.



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

Expert:  flopcat98 replied 4 years ago.
what do you mean by "go to sheet 2"

You can put a formula on sheet 2 that will only copy them if they have n2 in that cell but you will get blanks where it was not n2.

again what is your ultimate goal ? what do you want to see ? there may be much better and easier ways to do it than what you think you want but cant do
Customer: replied 4 years ago.

what more do you need from me

Expert:  flopcat98 replied 4 years ago.
I am going to opt out here.

Related Microsoft Office Questions