View Single Post
  #1   Report Post  
milljaso
 
Posts: n/a
Default continuous cell function


I am trying to create a function from a worksheet that has market data
and changes every week. example: Worksheet 1
A B
1 10/15/04 250
2 10/22/04 275
3 10/29/04 ?

and....
On Worksheet 2, I want to have cell A1 represent the most current
changes each week I input the market data plus additional function. So
currently I have the A1= worksheet1 B2+100. So without inputing a whole
new function I want A1 on worksheet 2 to automatically read whatever I
input into B3 from worksheet 1.
Please Help!


--
milljaso
------------------------------------------------------------------------
milljaso's Profile: http://www.excelforum.com/member.php...o&userid=15789
View this thread: http://www.excelforum.com/showthread...hreadid=272981