[desmon1]

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

[ScottGem]

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.

[NeedKarma]

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