How to change numbers in entire spreadsheet from one cell?

[Guest]

What I'm trying to do is take a spreadsheet that is already setup with
various formulas and functions and use one cell to change the contents of the
others. For example if in that one cell I have a 5, then all the other cells
should represent the result of the function or formula multiplied by 5. Or if
I entered a 3 everything should be multiplied by 3.

Is this possible?

 

[Ken Wright]

Yes, and quite easily:-

Assuming your data is in say C5:Z100

In say cell A1 put 3
In say cell A2 put =$A$1
Copy cell A2
Select all your data in C5:Z100 and do edit / Paste Special / Check
'Formulas' in the Paste Section and 'Multiply' in the Operation section
Hit OK and then delete cell A2.

Your cells are now all linked to cell A1, regardless of whether they had
held values or formulas, and if you change A1 you change everything.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Anne Troy]

Easiest method (to me) is to put the value in a cell. Name that cell, such
as "intrate" for interest rate. In your formulas, just type =A3*intrate
*******************
~Anne Troy

www.OfficeArticles.com