Need excel to generate unique number on click of a button

[Maddy01]

I'm trying to set up a system of sorts to track "services"

At the top of my 'new service" page, I need a button, which I then need to have a macro run on.

Sheet 1 is basically where I'd be entering the info, and sheet 2 where it would be stored. The button at the top is called Generate New "service' Number. This then needs to generate a new number on sheet 2 in A2 (then once 2 is populated, generate new in 3, then 4, then 5 etc...

I have a macro on Save Service Button at the bottom, which transposes the data into what would be used as a database to store all the services. That Macro then also needs to only transpose and paste data into the row corresponding with the "service number".

 

[vds1]

To Generate Random Number In excel

=RAND()*10000000

To Generate Random Number In Vba,

Round(Evaluate("=RAND()*10000000"),0)

 

[Maddy01]

Thanks, but they can't be random. They need to follow - like invoice numbers would.