NateO
couldnt get it to work. I'll try to explain better what I am trying to do.
I created a simple invoice on a worksheet. I then fill in the information on the worksheet, print the worksheet, press a button, which then puts the name on the invoice, contract number and price on to another worksheet which i call a log. What I need to add is a way to press the button which then "logs" the info and assigns a new contract number. Hence contract+1. If there was also a way to clear the contents at the same time I press the button and assign a contract number would be great. Thanks