what equation should I use?

S

savio

Hi All,

In excel what equation should I use to do the following:

On one, excel sheet and particular location ( say A1) I have a number
that changes daily (updated from the net). I want to show each day's
value (new number) in the next line down from the day before, in the
second sheet.


Regards,
 
C

CLR

This is not somethine you can do with just formulas, you will need to get in
to VBA macros.........either manual (punch a button to fire the macro and
produce your result), or automatic (change-event type which will run
automatically each time the file is opened and/or the sheet is chosen,
etc.................if you are interested in that sort of effort, post back
and someone will help you...........

Vaya con Dios,
Chuck, CABGx3
 
Top