View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jessica Jessica is offline
external usenet poster
 
Posts: 113
Default Automatic Formula or Macro

Hello all. I have created purchase order system that I would like other
employees to use. What I would like to happen is that every time the PO
workbook opens the number in "L1" in "Sheet1" automatically increases by one.
So if I save PO 00001. The next person who opens it will autimatically get
PO 00002. How do I accomplish this? Thanks for your help!
--
Jessica