How to Change # Field When Printing in Excel...PLEASE HELP!!!?

Question

I am creating a PO Sheet and I have a field that has a PO # in it...say A-1001 and I need it to increase each time I print it by 1 number, or if I want to print 25 of them I can set it to print A-1001 thru A-1025. I am not sure how to make this field do this or if it can even be done...PLEASE HELP

Answer 1

You need a macro for that. Don't worry, someone will come along and show you how to write one.