cell formula in Excel 2000

April 11, 2009 at 17:26:43
Specs: Windows XP, 2 gb
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.

See More: cell formula in Excel 2000

Report •

April 18, 2009 at 03:46:37
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

Report •

April 18, 2009 at 07:47:38
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.

Report •

April 18, 2009 at 07:57:29
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

Report •

Related Solutions

Ask Question