VBA Macro - invoice - add data to the record fail

[tr4mp3r]

Hi everyone,

I'm creating a new invoice system where I want a macro that lets me generate a new invoice number and then automatically records the data of the previous invoice in a different sheet.

Please have a look at the code and let me know where i went wrong, thank you so much in advance!

tr4mp3r

 

[Belleke]

What can we do with a textfile, post an excel example.

 

[rlv01]

Please have a look at the code and let me know where i went wrong

First, tell us what you think went wrong.