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
|