Hi Leonard

for help on incrementing invoice numbers check out
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

if you'ld like a sample workbook that shows an incremental invoicing system
with a summary sheet and different pivot tables & reports that you might be
able to get some ideas from or customise for your own use email me direct at
julied_ng at hcts dot net dot au.

Cheers
JulieD


"excel help" wrote in message
...
How can I setup a control or whatever is needed to ensure that each time I
click on a control button named Invoice that it brings up a fresh invoice
with a new invoice number and when closing it saves that invoice to a
named
folder location allowing next invoice to start,

hope this is clear enough,

Leonard