I export data from Quickbooks into excel. Quickbooks unfortunately doe
not let me filter the data with two variable, because if should be <0
In Quickbooks you can only filter on = or or <.
So I export this huge data block into excel to then import int
access.

When the data is imported into access, I run a macro which massages th
data into a format access can use.
I now have more then 10,000 rows to copy and it has reached the limi
of some of the computers memory.
Out of the 10,000 or more transactions, there are more 4,000 items wit
the value of zero, which I can get rid of.
I would like to be able to add some lines to go through the rows an
delete all rows where the value in column J=0.
Thank for any help.
Ann

--
anne
-----------------------------------------------------------------------
annep's Profile: http://www.excelforum.com/member.php...fo&userid=1885
View this thread: http://www.excelforum.com/showthread.php?threadid=49708