Simple Purchase Order

So I am thinking about making a simple purchase order file the one thing that I would like is having the purchase order number automatically increase as I add sheets.

Example first PO # 0001 then when I duplicate the sheet the next number would automatically go to 0002

Anyway of doing this?

Jack

John McGimpsey shows how you can do that here:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Hope this helps.

Pete

I think that is what I am looking for, Thanks.