formula that calculates upon saving only

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formula that will only calculate when the page is saved with "save
as" only. This will be a reconcile spreadsheet for a retail store. I want the
petty cash end of day (H21) to become the petty cash start of day(J3), for
the next day. Is this possible? I want it to only work for "save as" b/c the
managers will be opening and closing this spreadsheet all day, so they will
have to save but I think they could use "save" for that & "save as" the final
time.
 
I don't know if you can differentiate between save and save as.

But, in listening to your whole problem, I'd just make a macro button for
them to push that would run your special macro.
 
Thanks Tom,
I am really having problems with Macro. I am not that skilled. Do you know
of a quick instruction page. I've been using a book but its's made for 2003
not 2002. Any help you can provide is appreciated.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I import text file of cash flow to excel file then use formula 1
help with protection of sheets 3
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Lookup Formula: Return 1st match, then 2nd match, then 3rd match 4
I want to create a savings cash flow according to what I spend/sav 1
What are the steps to fix damaged MDF files in SQL Server? 0
Expanding Date formula 1
how to carry balances from one worksheet to another 2

Back
Top