I am working on a problem. I have two work sheets in a single workbook. I sheet 1 i have (say) rows:
and in sheet 2 i have some data like:

100 200 A B 12
200 300 C D 13
300 400 A B 14

I want to hyperlink cell 1 in sheet 1 to the data in row 1 of sheet 2. I am able to do that with hyper link option. But, my objective is to hyperlink cell 1 in sheet 1 to row 1 of sheet 2 and display only the row 1 instead of highlighting row 1 data in the given set of sheet 2 data.

Only the hyperlinked data is to be displayed in sheet 2 from all the available given data set.

Could any one help me on this.