Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating concurrent data on a worksheet and adding new row | New Users to Excel | |||
Updating data from one worksheet to another | New Users to Excel | |||
Updating data in one Worksheet and propagating it to others | Excel Worksheet Functions | |||
Comparing Data and Updating a worksheet | Excel Discussion (Misc queries) | |||
Automatic updating worksheet data between different workbooks | Excel Worksheet Functions |