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