hi all,
I logged a thread in the other area with no luck.
I have an excel workbook with two sheets.
Sheet one has a colum of data. Sheet one has the unique values
Sheet two has the same information. sheet 2 has the same info but multiple times.
So simply all i want to do is when i click on a cell in sheet1, i wanted a search to be activated on sheet2 for that data.

Eg there is one colum on sheet1 which contains data.
When i click on any of those cells it will then get that data and search for it on sheet two.

For instance col B in sheet one contains :
1
2
3
4
5
6
Let say i click on the cell that contains 5, then a search for 5 will start on sheet two.
any help would be appreciated.