I am not that advanced in Access so excuse me.

I am looking to write a macro that imports an excel spreadsheet, sort by one column and every change in that column split the data and print it out on a report.

I was able to write a macro to import the data from excel, and other macros to run reports by the sorted column.
But if there is a new data in the column I wouldn't have a macro set up for it already. Also when printing out the report I can't get the macro to read the report format that I set up with the custome footer and header and column widths.

Thanks for all your help.