Hello. Had lots of help to create this excel sheet with macros. Im a doctor that works in a dermatology department where we carry out lots of allergy tests. A number of years ago someone helped design the attached macros etc to allow staff to select the batch of allergy tests they want out of a huge list, and then print off the selected tests only. It works a real treat, but, for example, if you click the first batch of tests, in print preview (And final printed document) it always produces as extra black border line (presumably from the top of the next batch of tests)
All very complicated but if you have a look at the document (with macros enabled) im hoping you'll get a feel for whats needed. If you can get rid of the extra black line id be delighted !
I think I might have tried before but is there a way to automatically make a new page for printing at the end of each batch of tests (rather than splitting them over two pages)- currently having to use page break mode everytime and change where the page splits. If that could be automated it would be a dream !
Sorry Im a real novice.
Cheers
Bookmarks