Filter query and loop through records

Question

I have a customer sales table that I need to filter for unique customer numbers, loop through the table and pull all records with that customer number out and export to an Excel workbook.  Then move to the next unique customer number and add that data to a new sheet in the same workbook and so forth until the end of the table.  I know nothing about VBA and therefore will appreciate all of the help you experts can provide.  Thanks! 

All,

Thanks for your input on this it was very helpful.  That said, I was able to figure out an Excel VBA macro to accomplish this.

Randy