Well, I programmed a macro to do this using record macro and clicking around a lot. It worked, but now the page numbers on the first worksheet change from 1 of 2 and 2 of 2 (a printed on two sides document) to 1 of 7 and 2 of 7. How can I prevent this from occurring?
Thanks!