View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Teddy-B Teddy-B is offline
external usenet poster
 
Posts: 76
Default GO To / FIND / QUERY / DATA ~~HELP?!?

Thanks for looking. I have a list of social security numbers on file in a
single column of a spreadsheet. The other related colums contain data such as
last, first names, birthdays, etc. I would like to set up something like
CTRL-f and go to the whole row that contains the SS# and all related info. I
have set up a data box that the user will input the SS# that they want to
query. I just need to know what to use to go to the row taht contains the
data.

Any suggestions will be appreciated

PS~ I don't want to use CTRL-f becuase it leaves the find window up and it
looks a little tacky.