Auto Number Forms Prepared In Excel

By dpouppirt ·
I have created several forms using Excel (2000/2003), i.e., purchase orders, for my company.

We need the forms to auto number in increments of 1 (001, 002, 003) and only increment when the document is saved.

We also need to be able to track who requested the purchase order form/number. But if I could just get it to auto number to start with that would be great. There will be multiple users needing purchase order numbers.

Can anyone help (I'm an above average Excel user, but not really a whiz when it comes to programming codes).


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

I hate to state the obvious, but....

by robo_dev In reply to Auto Number Forms Prepare ...

use a database or buy a simple app to do this

When you goto produce a report of total purchase orders sent to vendor X for the year, you will thank yourself for using a database instead of a bunch of spreadsheets. Or when one of your users keeps re-saving each new PO over the old ones.

Here's a PO software package for $239 USD

Related Discussions

Related Forums