I have a report I have written in Excel using multiple sheets.
some sheets have a single page, some have multiple pages.
I want to put page numbers in the footer as I also have to put time, date, filename in the footer due to company layout rules.
All the page numbers are referred to in the index in a 1.1, 1.2, 1.3 type format and have to be done that way, again for company layout rule (Boy am I glad this is a contract!!)
I can't work out how to have the page numbers working in consecutive order where I have the multiple pages on a single sheet.
Anyone have any ideas?
Thanks
Simon
Bookmarks