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

[Tyler Hopfner]

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?

 

[L. Howard Kittle]

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