:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

You would need to do this with VBA code. I'm not so sure it's a good idea though. What happens if you just want to open the file to look at the last invoice. What I would do is record a macro to add 1 to the Invoice number, then make a button to run that macro when you want.

Quote:

---

Originally Posted by ScottGem

. What I would do is record a macro to add 1 to the Invoice number, then make a button to run that macro when you want.

---

My name is Need and I approve of this answer.

:thumbsup: