Hi,

I am downloading a report from Quickbooks that gives me
transaction details such as Customer Name, Date, Item
Number, Item Name, QTY and Total. Quickbooks then
provides a subtotal for each customer. In this row, all
of the other data in blank (there is not name, date, item
number etc in this row. What I want to do is to create a
macro that only has the transaction data in it and strips
out the subtotals. What I have done is to sort the
workbook by data which give me what I want. However, at
the end of the spreadsheet is all of the subtotals by
themselves with the blank data in all of the other
columns. I would like to delete these somehow. The
problem is that there is no set row that they start on.
One day it will be row 3465 and the next it will be
3531. I then plan to import this into Access but I don't
want the subtotal data to be imported and I can't figure
out how to filter it out during the import. Can anyone
help?

Thanks,

Chuck