Help with problem

  • Thread starter Thread starter jtees4
  • Start date Start date
J

jtees4

Trying to figure out how to do this. Lets say I have a large excel
workbook...maybe 20 pages.....100 rows in each.
I want to look up a name in column B....and return all of this name
along with the data in an adjoining column. Hope this makes sense.
Thank you.
 
you are not being clear, I found from my experiance that the more
clear you are the better help you'll get, so take time in making up
your posts.

You want to look up all the records in column B or just some ?

Maybe you just want to see John Smith only ?
 
you are not being clear, I found from my experiance that the more
clear you are the better help you'll get, so take time in making up
your posts.

You want to look up all the records in column B or just some ?

Maybe you just want to see John Smith only ?
Click to expand...

Sorry....yes I want to pull out all the John Smith's in column B from
many sheets and then return a value in an adjacent column to John
Smith. I want the result to be a new sheet with only the John Smith's
on it. Thanks.
 
Back
Top