Hey all. I have been using excel for some time, but have just started
getting into the programming and other sides of Excel. For a spread
sheet that I am working on, I currently get updated prices sent to me
every week and it is about 80 prices. What I would like to do is every
week when I get the sheet and have it update other things automatically,
I would like it to store the price in one column, and then update the
price in another column, and take the differential. Is this possible?

Example:

Stock Prices I get on 6/13 - store in Current Stock Price
Stock Prices I get on 6/20 - store in Current Stock Price, and move
6/13 to last week. I then want to subtract the two.
When 6/27 comes, I want to delete 6/13, move 6/20 to where 6/13 was,
and move 6/27 to 6/20. Is that possible?

Or, is it possible to take the date, and convert it somehow to a
number, and say if column A is less than column B,copy column B to
column A? if so could someone explain that as well. Thank you.

Thank you

Ben Farkas



--
TrippinAnts22
------------------------------------------------------------------------
TrippinAnts22's Profile: http://www.excelforum.com/member.php...o&userid=24636
View this thread: http://www.excelforum.com/showthread...hreadid=382251