In principal thats what I'm after. I need the link to be able to open a seperate (and printable) data sheet, a sort of running log sheet that contains a basic data set with space for a running commentary. I wonder if this is something that can link the front sheet to individual sheets.
I also wonder if this is something that might run better from access.

Hi Steve
Access may be an option if you know how to use it well enough.
However what I have done is insert page breaks which allows 3 columns per page. You can adjust the width of any of the columns as long as the total width of the 3 columns does not exceed the current page width in your printer setup.
To print an individual page simply click on the link for the page you want to print. Your cursor will be placed in the top left hand corner of that page.
Then click on File followedby Print (do not just click on print or the whole workbook will be printed). Then enter the page number you want to print.
Hope this helps.
Tony (OTPM)

Attached Files

Book1.xls (17.0 KB, 11 views)

I think I need to evaluate what you hav said and research access functionality some more, My kids are doing A level ICT, time to pick there brains once exams are over