Gathering info from one sheet and making a list on another sheet

[jimayers]

Hi, I need a code to lookup up a value (such as "Q1010") on a worksheet(1) and when found, put the values from its left and right cells on a list in another sheet(2). It would be nice if the new sheet(2) list could be organized by numerical order according to the value of the cell on "Q1010" right.

I tried vlookup and it did not work, then I got help using .find which is going ok, but I am having trouble making a list without leaving blank rows.

Thanks for any help - JA

 

[FDibbins]

I tried vlookup and it did not work

what happened when you used it...wrong answer? no answer?

Will you have more than 1 return for the search?
Can you share some sample data and expected outcome?

 

[jimayers]

Another feature I have gotten to yet, but would appreciate help with, is how to enter the search value "Q1010." I was thinking of 3 different ways:
1. Use check boxes next to every row, and when the value is found by scrolling through data, the user puts a check and that triggers the macro to put "Q1010" cell and the cells to its left an right on the list.
2. click on the cell with containing the desired value, "Q1010," and that triggers the macro
3. enter the desired value, "Q1010" into a box, userform, cell, whatever.
All three options for user choice of how to search would be ideal.


Thanks for any help - JA

 

[jimayers]

worksheet(1)
A B C D E
1name add Q1010 phone other info
2name add Q1011 phone other info
3name add Q1012 phone other info
4name add Q1013 phone other info

search for Q1010...then Q1013...so on
worksheet(2)
A B C D
1 add Q1010 other info name
2 add Q1013 other info name