Thread: Can I create a cell that will count by one every time I print the.

I want to make a cell that will count up by one every time I print the
document. It would also be nice to link the cell between a bunch of
documents. I am tired of using a purchase order book and have created
individual po's for every vendor with their specific information, but I want
an eaisy way to change the po# every time I print. Is this possible? or is
there a better way?

Hi Tyler,

You could use the ThisWorkbook BeforePrint event macro to increment the PO
#. I have seen some pretty good instructions on the whole issue, by J.E. et
al, but sorry, I don't have the link.

HTH
Regards,
Howard

"Tyler Hopfner" <Tyler Hopfner@discussions.microsoft.com> wrote in message
news:C3F44D36-6369-4EC0-9E7E-14B51740D97E@microsoft.com...
>I want to make a cell that will count up by one every time I print the
> document. It would also be nice to link the cell between a bunch of
> documents. I am tired of using a purchase order book and have created
> individual po's for every vendor with their specific information, but I
> want
> an eaisy way to change the po# every time I print. Is this possible? or is
> there a better way?