I have a workbook with about 16 admin and finance sheets. Then the rest of sheets contain the data for each job, like job cards. These sheets are coloured blue and the admin sheets are coloured green. I have been asked to create another admin sheet with a dynamic list of sheet names with hyperlinks. But they only want the blue sheets to be shown on this list, so they can easily navigate to the job cards to update them.
I am stumped.
Any help would be greatly appreciated.
Thanks
Jason Bing
I am stumped.
Any help would be greatly appreciated.
Thanks
Jason Bing