I am trying to build a report xls from xml file.
Where i have a requirement , the first sheet (main report page) has the summary of number of each entitty changes and each entity detail rows are listed in a separate worksheets i.e. sheet1--> entity1
sheet2 --> entitity2 etc.
when i click the hiper link of changes number , aganist the each entity name (i.e row) in the main report sheet it should navigate to the respective entity work sheet in the work book.
could you please help with a sample if possible.
please find the sample attached file designer.xls