Browse to a specific sheet in an excel workbook
I have information on separate states of USA in separate sheets of an excel workbook named 'A.xlsx'. The name of each sheet is a unique state name.
I have another excel workbook - 'B.xlsx' where I have a table and each row of the table needs to have a url to one of the sheets of workbook A. If I want to know the information about California I click on its specific URL which should take me to its specific sheet in the workbook A. Similarly, if I want to fetch information on Kansas I should be taken to the sheet named Kansas in workbook A.
How can I achieve this?
|