Notifications
Clear all
VBA & Macros
4
Posts
2
Users
0
Reactions
76
Views
Topic starter
I am currently building an invoice in excel and am trying to create an invoice sheet that uses a macro to copy over the information onto a separate sheet with all of their personal details. I need to make a macro that copies over the details and increases an invoice number by +1 each time with a new row being inserted as well. I have tried to make formulas to complete this but to no avail, I cannot figure out how to do this.
Any sort of help or information would be greatly appreciated,
Thanks.
Posted : 22/02/2020 3:10 pm
Hi Taylor,
If the invoice number is in A1 try this
ActiveSheet.Copy After:=Sheets(Sheets.Count)
Range("A1").Value = Range("A1").Value + 1
Regards
Phil
Posted : 23/02/2020 12:36 am
Topic starter
Hi it is in A2, so would the process be the same?
thanks
Posted : 25/02/2020 3:58 am
Yes, just change Range("A1") to Range("A2")
Posted : 25/02/2020 7:32 pm
