Hyperlink based on summary data...

[shaukat]

Dear all,

I need your help to hyperlink summary data in sheet2 to it source data in sheet1. Each summary Row in sheet2 is referred to a block of data in sheet1, these blocks have different items and number of rows, so can not be summarized. there are hundreds of blocks.for example if I click company name "ittafaq" in summary data. it may direct me to source of this data in sheet1 "ittafaq". can we use loop to link this data? any help or clue is highly appreciated.
Thanks and Regards.
Shaukat

[shaukat]

experts any ideas ?

thanks

[JBeaucaire]

Without programming, this formula can be put in F4 of sheet1 to give you a clickable hyperlink to the entry in D4:

=HYPERLINK("#'Sheet2'!" & ADDRESS(MATCH($D4, Sheet2!$A:$A, 0), 1), "Link")


.... or put this IN D4:

=HYPERLINK("#'Sheet2'!" & ADDRESS(MATCH($A4, Sheet2!$A:$A, 0), 1), A4)

[shaukat]

Hi JBeaucaire,
Thanks for this sharing, But my data is based on too many rows, can not put formula one by one in each cell. if I know how to pass cells , address or range in hyperlink argument. this tasks will easy.But I think this is limitation of hyperlink command it does not allow cells(i,j) object method.
any views?

thanks

[shaukat]

this formula gives link from sheet1 to sheet2. I need to have from sheet2 to sheet1.

thanks

[shaukat]

i changed the values other way round, it works. thanks for your great sharing

[JBeaucaire]

Glad you got it working.