This is a continuation of a recent question. I am now trying to sort and subtotal a spreadsheet from VBA. I have tried to glean from the previous question a method to do this but have been unscuccessful. I have attached an Access database. The procedure ExpLabDist contains the code that works up to a point which I have identified. I have added code from Excel macros to sort and subtotal the spreadsheet created in the code. This code will not work as is. I find the coding in Excel fairly straight forward. However when attempting to duplicate the actions in Access I am confused. So I need assistance to convert the excel macro code to something that will work in Access. Also I would appreciate anyone who could give me some rules of thumb or instruction on the art of converting Excel macros into workable code in Access. Thank you.