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
Bookmarks