Last x entries on a moving list?
 

Hi there, any help much appreciated with this problem.

I download some data from a website into excel and it works perfectly
to give a list of rows with all the required info.

It updates regularly with the new data on the row below. So I might end
up with 30 rows of data with the latest at the bottom.

I need to be able to use the bottom, or most recent row of data, in a
calculation but think I need some code to catch it.

Any ideas on how I can capture the last 'x' rows of data from a
worksheet?

Thanks


--
Raigmore
------------------------------------------------------------------------
Raigmore's Profile: http://www.excelforum.com/member.php...o&userid=30071
View this thread: http://www.excelforum.com/showthread...hreadid=520500