View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default I want to use a link to return all data matching a criteria

I have 2 worksheets, one with time used and the second with parts used. They
are tied together with an ID number. I want to create a link on the first
spreadsheet that returns all the values that match on the second
spreadsheets. I would like the matching results displayed in a third
worksheet.

I know I can do this using SQL and ASP, but the request is that I distribute
this is an Excel SS. I am using Excel2003.

Is this too much to hope for?

Thanks