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