Ok i have a spreadsheet that im working on with nearly 56000 rows of data that i need sort and combine together. The best way i can show you my problem is link a small format of what im trying to do as an example. Basically i have 3 different columns i need to worry about. The first is Store Number, the second is the Model number being sold in the store, and the third is the quantity of items sold sold per model number. Now the data is given to me all separated by transaction and it doesnt pair up the same model numbers. So if someone buys Item 1 of ABC early in the morning and another person buys 2 more of ABC later in the day it shows on the report as two separate listings instead of totaling the 2 to make a combined quantity of 3. What i need to find out how to do is take all of ABC that was sold under store 1 and sum it all up to make a total. Now i tried doing subtotals which does what i need it to do, but i need to export JUST the subtotals to Access. But everytime i try to do this it exports all that data plus the subtotals. The link to the file im talking about is members.cox.net/ringod30/Book1.xls.