I have several lists of data in an excel spreadsheet, when I print them out I need the top line of each page to contain headings.
My problem is that printtitlerows will print the same header ON EVERY page, I want this header to change depending on what list is being printed at the time.
eg if printer is currently printing list B then the header for this page should be B...
printtitlerows only allows one heading to be printed, its VERY INFLEXIBLE..any help appreciated.
[email protected]
