Software

Ask something
Question Locked

Auto Number Forms Prepared In Excel

0 helpful
2 replies

by dpouppirt

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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).

Thanks.

2 replies

by robo_dev

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
http://www.waverlystreet.com/po.html

This discussion is closed to new replies.