Getting last entry in a range

  • Thread starter Thread starter wwfc_barmy_army
  • Start date Start date
W

wwfc_barmy_army

hi,

I've got a 'quotation system' and i need to work out a way, so when
press i button (I've got the button) it recognises the last entry pu
in 'Customer Details'.

I just need some idea of the marco or whatever i will have to use.

Can anyone give me any ideas on how i can do this.

Thanks.

Pete
 
To find the last row of data try
=LOOKUP(2,1/(Data!A$1:A$20000<>0),ROW(Data!A:A))
use this with
="A"&LOOKUP(2,1/(Data!A$1:A$20000<>0),ROW(Data!A:A))
etc
Cant remember who posted it (sorry) but its really good,
Regards,
Alan.
This incredible formula (and it works!) was posted on the neswgroups not
that long ago
 
Back
Top