Consequtive numbering spreadsheets

[lstoner]

Can you consequtivly number excel spreadsheets? I have a basic form I made and I'm using it as an invoice. After I fill in the form I save it under a new name. The next time I bring up this blank form I would like the next form to come us as form number 2 and so on and so on.

Thanks Lisa

 

[Mark O'Brien]

Yes you can.

But do you mean, is there some way to do this automatically?

 

[lstoner]

YES, I WOULD LIKE TO DO THIS AUTOMATICALLY IF I CAN.

LISA

 

[Mark O'Brien]

You'll need to use VBA and probably sacrifice one obscure cell in your workbook. Still interested?

 

[lstoner]

Yes I'm interested, if it is not too difficult. It is something I could really use in my business.

Thanks Lisa

 

[lstoner]

Yes I'm interested, if it is not too difficult. It is something I could really use in my business.

Thanks Lisa

 

[Legacy 98055]

Hi Lisa

Do you save your sheets as a seperate workbook?
or
As an added sheet to the current workbook?

Tom

 

[lstoner]

Hi Tom,

I save my sheets as a new workbook

Thanks Lisa

 

[Legacy 98055]

I can either try and explain
how to accomplish what you need,
or you can Email me the sheet,
I'll add the code in, and mail
it back. Then you can go through
the code yourself if you'd like.
Not sure if you are wanting to learn
how to do this or just get it done?
Personally, I would add a button which
would automatically save the sheet
with the new name(number) and clear
the current form for the next invoice.

Tom

 

[lstoner]

Tom,

Yes, I would really like to get this done.
I would like to learn how to do it, but it might be over my head. I don't know. I can't email you the sheet until tomorrow because it is on my computer at work.

Thanks Lisa