Hi All

I have a list of data that has been "dumped" from another system int
Excel, that fills Columns A thru N. I need to extract from this al
rows that have the number 1 in column G, however I cannot seem to b
able to correctly define my criteria for this to work as I keep gettin
a Reference is not valid error

Is what I am trying to do even possible ?

Thanks in advance

Kare

--
ks
-----------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...nfo&userid=626
View this thread: http://www.excelforum.com/showthread.php?threadid=48808