Made a "Sale Reciept" and figured out all the cells except the "Invoice Number". How do you make the silly thing count to the next number....from 1 and the next time you open it up it will be on 2.

Do you mean the next time you EXIT the workbook and open it again? Formula's really do not work like that. They are more like calculators. And because the data hasn't changed since you last exitted the workbook, the formula will still produce th same answer. I think the esaiest way around this is to use VBA. You can create an event to run everytime the workbook is opened. Another possibility would be to add a button to the woksheet that triggers the code. How ever!!!!!! This means you are relying that the users have macros enabled, or Macro security set to low. Hers some code to try ------------------------------------------------------------------------------------- Private Sub Workbook_Open() With Worksheets("Sheet1").Range("A1") .Value = .Value + 1 End With End Sub -------------------------------------------------------------------------------------

Thanks, I'll give it a try. A friend of mine showed her Quickbooks, I might just uses it instead. Thanks again for your help.

If I'm understanding you correctly, and if you have Access, you could perform the task in that. AND........ Import your already existing excel spread heet What happened to my quote