Thread: updating value in a range of cells

hi all!

i have to update a workbook on daily basis.
today I am having values from A1:A3 as 50,60,70
& B1:B3 10,20,30. while updating tomorrow i will
change only the values in B1:B3 to 20, 30 & 40 and doing so
the values in A1:A3 should change as A1+B1, A2+B2 & C1+C2
ie) 70,90,110. the next day the values in B1:B3 will be changed
into some other values and A1:A3 should show the value
as A1+B1, A2+B2 & C1+C2


is it possible by any worksheet function or else..?


hlp pl..!


-via135

You can do this with Copy and Paste Special. First, type the amount by which B increases in a cell, copy the cell, then highlight the range in B, Paste Special, Add, OK. Then copy the range in B, highlight the range in A, Paste Special, Add, OK. Doing it automatically would require VBA, but doing it this way should only take a few seconds each day.

Hi,

See attached sample ...

HTH

Originally Posted by JeanRage

Hi,

See attached sample ...

HTH

hi
jean..pl check your file.!

i couldn't get any useful information from the attached file..!
totally confused..!


-via135

Originally Posted by via135

hi
jean..pl check your file.!

i couldn't get any useful information from the attached file..!
totally confused..!


-via135

As indicated in the Sheet, just input numbers in Column B ...

HTH