P
Pauline
Hi, I have built an invoice using Excel 2000, have inserted all the
necessary formulas and protected it, then saved it as a template in Excel.
I have put a label which says Invoice No. and in the next cell tried various
formulas to make the number increase by one every time the invoice is loaded
from the template, but can't make it work, it just displays Invoice No 1
every time. I would like it to say Invoice 1, Invoice 2, Invoice 3 etc each
time. Not sure how to go about it.
Any advice would be gratefully received. Thanks in advance.
Pauline
necessary formulas and protected it, then saved it as a template in Excel.
I have put a label which says Invoice No. and in the next cell tried various
formulas to make the number increase by one every time the invoice is loaded
from the template, but can't make it work, it just displays Invoice No 1
every time. I would like it to say Invoice 1, Invoice 2, Invoice 3 etc each
time. Not sure how to go about it.
Any advice would be gratefully received. Thanks in advance.
Pauline