Linking to Cell question

D

Dave

Hiya

I have a spreadsheet where each month, a new figure is entered on the
row below :-

JUNE 94.00
JULY 55.00
AUGUST 79.00
and so on.

That new monthly figure is copied over to another worksheet on the same
file. Normally I just copy and paste it, but is there a formula by
which the cell on the other worksheet can look at the most recently entered
monthly figure and then update automatically when the next months figure
is entered.
 
D

dderolph

Don't know of a formula to do it, but you could record a macro whic
simply places the cell pointer at the top of column on the source shee
that contains the monthly data, uses End/down to go down to the bottom
i.e., the most recent month, and copy that value to the cell in th
other/target sheet
 
Top