: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.

. 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: