Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating concurrent data on a worksheet and adding new row Northern Bytes New Users to Excel 3 January 20th 10 08:31 PM
Updating data from one worksheet to another joe2017 New Users to Excel 3 April 2nd 09 12:24 AM
Updating data in one Worksheet and propagating it to others Number1Dub Excel Worksheet Functions 1 July 4th 08 01:40 AM
Comparing Data and Updating a worksheet rbiggs Excel Discussion (Misc queries) 0 December 12th 06 12:52 AM
Automatic updating worksheet data between different workbooks Yiannis Excel Worksheet Functions 0 December 28th 04 12:01 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"