Log In
Register
Home
How do I increase a number by 1 for every new row created?
Taylor Brown
New Member
Members
Forum Posts: 2
Member Since:
February 22, 2020
February 22, 2020
Offline1
February 22, 2020 - 5:10 am
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.
Philip Treacy
Admin
Forum Posts: 1518
Member Since:
October 5, 2010
October 5, 2010
Offline2
February 22, 2020 - 2:36 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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Emma Klonowski, Murat Hasanoglu
Guest(s) 12
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 204
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Jefferson Granemann
Glen Coulthard
Nikki Fox
Rachele Dickie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27291
Member Stats:
Guest Posters: 49
Members: 31912
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —