View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bcoleman75 Bcoleman75 is offline
external usenet poster
 
Posts: 5
Default I need a cell to change numbers each time it is opened up.

I need the formula or path to i guess to make a template and each time it is
open it generates a new number, Like a invoice number. For example. in cell
A1 Invoice #
in cell B1 we would have the number 1. then save it and then when you open
the template again the #2 would be in cell B1 automatically? can anyone help?