Getting last entry in a range

[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

 

[Alan]

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

 

[Gord Dibben]

Pete

See Bob Phillips' site for various ways to find/return last value in a range.

VBA not required, but code is available there if wanted.

http://www.xldynamic.com/source/xld.LastValue.html

Gord Dibben Excel MVP