Keeping Formulas Results

[Bart]

How can I keep the values obtained by formulas in order to
compare them to the new values obtained once I make
changes to the variables that feed that formula?

In other words, I want an automatic way that would replace
copying and pasting as values the results obtained by the
formula.

Thanks a lot!

 

[Norman Harker]

Hi Bart!

Take a look at Tools > Scenarios.

You might also consider a lateral use of Ron de Bruin's SendMail Addin
that facilitates sending workbooks with current values only. Using
that option and sending to yourself allows easy creation of separate
"current values only" files for different scenarios.

For the free addin and user guide see:

Ron de Bruin
http://www.rondebruin.nl/Add-in

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 25th July: Barundi (Anniv of 7th
Republic), Cook Islands (Rarotonga: Gospel Day), Costa Rica
(Guanacaste Day), Cuba (National Revolution), Ecuador (Foundation of
Guyaquil Day), Faroe Islands (Vestanstevna), Haiti (Papa Ogou),
Puerto Rico (Constitution Day), Spain (Galicia National Day, Santiago
Day, St. James Day), Tibet (Yalong Cultural Festival), Tunisia
(Republic Day). Observances: Voudon (Papa Ogou St Jacques le Majeur).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.