View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135 via135 is offline
external usenet poster
 
Posts: 94
Default updating data in worksheet..!

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