I have created a database which in one sheet (Sheet 2) I have the data in rows and the other sheet (sheet 1) I have a search menu that based on the criteria inserted in the blanks I had provided it ranks the rows from the database and list the top 20 list under the "search menu".
since the ranked info on sheet 1 only has a few details to keep it simple, I want to be able to click on my ranked rows (i.e #1) and then link to the row that contains all the info about that row.
So if in sheet one I looked for a car that costs at most $1000 then it ranked the cheapest car at $850 (for line 1) then $ 900 (for line 2)...
I want to click $850 and then go to the database which will show me all the rest of the details... who the seller is, where he is located etc. (information that is already in the database)
Please help me ASAP Ive been searching for hours for a solution and I tried on my own for hours.
Thank You,
LK
since the ranked info on sheet 1 only has a few details to keep it simple, I want to be able to click on my ranked rows (i.e #1) and then link to the row that contains all the info about that row.
So if in sheet one I looked for a car that costs at most $1000 then it ranked the cheapest car at $850 (for line 1) then $ 900 (for line 2)...
I want to click $850 and then go to the database which will show me all the rest of the details... who the seller is, where he is located etc. (information that is already in the database)
Please help me ASAP Ive been searching for hours for a solution and I tried on my own for hours.
Thank You,
LK
