Shoutbox

Excel Help - Printable Version

-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: Excel Help (/showthread.php?tid=31212)

Excel Help by Petros on 09-10-2004 at 09:24 AM

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


RE: Excel Help by CookieRevised on 09-10-2004 at 10:08 AM

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...


RE: Excel Help by Petros on 09-10-2004 at 02:51 PM

thankz alot :)