I AM USING EXCEL 2000. I AM USING A INVOICE TEMPLATE THAT I OPEN AND SAVE EACH TIME I WANT TO USE IT. I WANT TO KNOW IF ANYONE CAN HELP ME DO A FORMULA OR SOMETHING THAT WAY WHEN I OPEN MY INVOICE A DIFFERENT INVOICE NUMBER WILL AUTOMATICALLY BE INSERTED WITHOUT HAVING TO DO IT MANUALLY?
Hi Vera
please don't shout (it's not good form to write in all caps .. .makes us
think you're shouting at us and it makes the post way more difficult to
read)
however, as to your question, if you'ld like to email me direct i have a
sample workbook that you can look at / use / modify whatever that
demonstrates how to do this & a few extra things.
Regards
JulieD
julied_ng at hcts dot net dot au
> I AM USING EXCEL 2000. I AM USING A INVOICE TEMPLATE THAT I OPEN AND SAVE EACH TIME I WANT TO USE IT. I WANT TO KNOW IF ANYONE CAN HELP ME DO A
FORMULA OR SOMETHING THAT WAY WHEN I OPEN MY INVOICE A DIFFERENT INVOICE
NUMBER WILL AUTOMATICALLY BE INSERTED WITHOUT HAVING TO DO IT MANUALLY?
ian - 06 Aug 2004 11:21 GMT
july i found your anwser in this forum im in the same situation ive been in
business for four month now and im growing i need excell to automaticly
number all my documents so i can keep track can you send me some info on how
to automaticly insert numbers on invoices and other docs
thank you
ian gemmell
idg home improvements
> Hi Vera
>
[quoted text clipped - 13 lines]
> FORMULA OR SOMETHING THAT WAY WHEN I OPEN MY INVOICE A DIFFERENT INVOICE
> NUMBER WILL AUTOMATICALLY BE INSERTED WITHOUT HAVING TO DO IT MANUALLY?
JulieD - 06 Aug 2004 11:33 GMT
Hi Ian
email me direct and i'll send it to you ... that way i'll know i've got the
right email address
Cheers
JulieD
> july i found your anwser in this forum im in the same situation ive been in
> business for four month now and im growing i need excell to automaticly
[quoted text clipped - 22 lines]
> > FORMULA OR SOMETHING THAT WAY WHEN I OPEN MY INVOICE A DIFFERENT INVOICE
> > NUMBER WILL AUTOMATICALLY BE INSERTED WITHOUT HAVING TO DO IT MANUALLY?
Claudia - 01 Mar 2006 19:48 GMT
Hi, Juli Im having the same problem can you please send me this info?? my
email is Claudiar2@msn.com
Thank u so much....
>Hi Ian
>
[quoted text clipped - 9 lines]
>> > FORMULA OR SOMETHING THAT WAY WHEN I OPEN MY INVOICE A DIFFERENT INVOICE
>> > NUMBER WILL AUTOMATICALLY BE INSERTED WITHOUT HAVING TO DO IT MANUALLY?