View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sara sara is offline
external usenet poster
 
Posts: 82
Default Automatic Update Upon Opening of Spreadsheet

I have a cell containing a number that I need to increase by an increment of
one each time I open the document. Is there a formula I can write that will
automatically do this for me? I am relatively new to the more advanced
capabilities of Excel, though I have a basic understanding of Visual Basic;
do I need to create a Macro or can I use a simple formula on the spreadsheet?
Thank you.