Hy

one way to do it is auto filter, select the data, copy and paste in another
spreadsheet

hope this help
Regards from Brazil
Marcelo

"danioma" escreveu:


I am having trouble with a lookup formula and was hoping someone could
help me. I have one list of invoices one on sheet and a column next to
them where it says paid or not paid. I am trying to pull only the "not
paid" amounts into another sheet but want to do this without the zeroes
or spaces in between rows. Any ideas how to do this?

Thanks!!!


--
danioma
------------------------------------------------------------------------
danioma's Profile: http://www.excelforum.com/member.php...o&userid=35112
View this thread: http://www.excelforum.com/showthread...hreadid=548678