Hi there,
I have an excel file which has macro to publish a report. Each report contains different no.of sheets. However in every file I have a master sheet in the first page and that contains the tab names in it. I usually manually hyperlink to the respective sheet. Is there a possible that everytime I ran a report and that master sheet automatcially create a hyperlink to the respective sheet (in the same file). This is dynamic in nature, not the same number of sheet and the constant sheet names.
Any help on this would certainly appreciate.
Thanks,
Ram
I have an excel file which has macro to publish a report. Each report contains different no.of sheets. However in every file I have a master sheet in the first page and that contains the tab names in it. I usually manually hyperlink to the respective sheet. Is there a possible that everytime I ran a report and that master sheet automatcially create a hyperlink to the respective sheet (in the same file). This is dynamic in nature, not the same number of sheet and the constant sheet names.
Any help on this would certainly appreciate.
Thanks,
Ram