Excel spreadsheet
 

I would appreciate help with the following problem I have:

Assume I have a row of cells named B1 and B2.
Today I want the value in B1 to be the product of A1 times A2.
Tomorrow, I will create another row of cells named C1 and C2. I will change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.
I do not want the old value in B1 to change from what it is today.
Can you help me with this?

Thank you very much,

Ron






--
rbane

Excel spreadsheet
 

Take a look at absolute and relative cell references

"rbane" wrote:

I would appreciate help with the following problem I have:

Assume I have a row of cells named B1 and B2.
Today I want the value in B1 to be the product of A1 times A2.
Tomorrow, I will create another row of cells named C1 and C2. I will change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.
I do not want the old value in B1 to change from what it is today.
Can you help me with this?

Thank you very much,

Ron






--
rbane

Excel spreadsheet
 

Ray,
I did look at absolute and relative references, but that does not help
me with my problem.
Thank you very much for your response and I hope someone can direct me
to solve my problem.
--
rbane


"Ray A" wrote:

Take a look at absolute and relative cell references

"rbane" wrote:

I would appreciate help with the following problem I have:

Assume I have a row of cells named B1 and B2.
Today I want the value in B1 to be the product of A1 times A2.
Tomorrow, I will create another row of cells named C1 and C2. I will change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.
I do not want the old value in B1 to change from what it is today.
Can you help me with this?

Thank you very much,

Ron






--
rbane

Excel spreadsheet
 

You will have to fix the values of today's calculation before you make
changes to A1 or A2. I think the following formula should be entered
into B1:

=$A$1 * $A$2

and format the cell how you would like it. Then, when you have entered
today's values of A1 and A2, copy the formula into C1 ready for
tomorrow, then select B1 and click <copy, then Edit | Paste Special |
Values (check) and OK followed by <Esc or <Enter. The value in B1 is
now fixed, and the same value will be shown in C1. Tomorrow you can
change A1 or A2 and C1 will also change - copy this to D1 then fix the
values in C1, etc.

Hope this helps.

Pete

Excel spreadsheet
 

Pete,
Thank you for your suggestion. I see exactly what you're saying and I
agree that will work.
However, I used one cell (B1) in my example, but in reality I have
numerous cells that I need to do this to every day and even though your
method will work, it will take me many hours to do that to every cell.
Can you think of a simpler way to do what you're suggesting to many
cells at the same time?
Again, I thank you for your time and your expertise.

Ron
--
rbane


"Pete" wrote:

You will have to fix the values of today's calculation before you make
changes to A1 or A2. I think the following formula should be entered
into B1:

=$A$1 * $A$2

and format the cell how you would like it. Then, when you have entered
today's values of A1 and A2, copy the formula into C1 ready for
tomorrow, then select B1 and click <copy, then Edit | Paste Special |
Values (check) and OK followed by <Esc or <Enter. The value in B1 is
now fixed, and the same value will be shown in C1. Tomorrow you can
change A1 or A2 and C1 will also change - copy this to D1 then fix the
values in C1, etc.

Hope this helps.

Pete

Excel spreadsheet
 

If the cells that you want the (daily) answer in are all in the same
row or column, then it is easy enough to just highlight that row
(/column) then copy the formulae to the next row (/column), and then
fix the data in "today's" row (/column). This way the operations take
place on a range of cells and it will take no longer to achieve this
than to do it for one cell. Obviously, you will have the changes to
make to several cells in column A, unless you copy/paste that from
somewhere else.

Hope this helps.

Pete

Excel spreadsheet
 

I designed a macro that is working fine thanks to your and others help.
Thanks again.
--
rbane


"Pete" wrote:

If the cells that you want the (daily) answer in are all in the same
row or column, then it is easy enough to just highlight that row
(/column) then copy the formulae to the next row (/column), and then
fix the data in "today's" row (/column). This way the operations take
place on a range of cells and it will take no longer to achieve this
than to do it for one cell. Obviously, you will have the changes to
make to several cells in column A, unless you copy/paste that from
somewhere else.

Hope this helps.

Pete