View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bfont bfont is offline
external usenet poster
 
Posts: 6
Default Looking up a row of data

I have a large spreadsheet, stock tickers in the first column, and a lot of
other data in the next columns related to those tickers. I want to have a
separate workbook where I can just type in a ticker, and it automatically
populates all the data from that ticker's row of data from the first
worksheet to the new one. Can anyone help with this???