Use DataFilter and create a criteria that extracts the non-blank rows to a
results area

"abdulie" wrote:


Autofilter doesn't work because there's headings in the way. I really
need something that would look up ranges of cells and delete any that
have not got a numeric value.

I think I'll have to do it in a macro or code to complete both steps???


--
abdulie
------------------------------------------------------------------------
abdulie's Profile: http://www.excelforum.com/member.php...o&userid=30538
View this thread: http://www.excelforum.com/showthread...hreadid=501930