Shoutbox

im trying to make a quote system for I.T and i want to know if theres anyway to make a automated invoice number changer... like every time i press my reset button the invoice number goes up by one... hellpp

You need to write a small macro to do that. (you need to attach al macro anyway to do anything with a button).

So, if your number is in B4, make a macro:

Sub Increment()
  Range("B4").Value = Range("B4").Value + 1
End Sub

Now make a button on your sheed and attach the macro Increment() to it...

thankz alot