I have a spread sheet for a CCTV audit and quality check.
I have two sheets: 1 - is the table of data and contains the button to view screenshots. 2 - is the screenshots sheet, all the screenshots are laid out in 'labels' relating to the camera they were captured with.
In a screen shot column on the first sheet I have a button that i want to take users to the second sheet of my workbook and to the corresponding screen shots listed on that page for that camera.
Is there a way I can do this in Excel 2003/2007?
Bookmarks