I have an Excel sheet I use as an invoice.
I want to print 100 pages and I want the invoice number to change from 1 to 100, so that each paper will have different invoice number.
How can I do this?
You need a macro for that. I found the following macro and made some changes on it. Try it to see if it works correctly:
I would use a macro to do this, as there doesn't seem to be an easy, built in method of doing this. The outline of the macro would be pretty simple. Something of this nature: