Linking to Cell question

  • Thread starter Thread starter Dave
  • Start date Start date
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.
 
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
 
Back
Top