ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   updating data in worksheet..! (https://www.excelbanter.com/excel-worksheet-functions/258194-updating-data-worksheet.html)

via135

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




All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com