Consequtive numbering spreadsheets

lstoner

New Member
Joined
Apr 25, 2002
Messages
7
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
 
Ok...

Couple of questions...

Do your saved invoices always go into the same folder or would you like the 'save-as' dialog to popup and allow the user to browse to a specific folder?

What is the starting number of your first invoice? What format?

Example: Invoice 000002
Invoice 2
ect...

Please include this info in the email and any other details which you need...

Thanks,
Tom
 
Upvote 0

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,215,054
Messages
6,122,893
Members
449,097
Latest member
dbomb1414

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top