File handling in excel
 

Hi,
This is a prototype table in access that I want to export to excel.

salesid businesschannel custid amt
001 A XXX 2000
001 A YYY 3000

002 A TTT 5000
002 A KKK 1000

Based on the above table I need to export to excel. This part is fine.
However,
I need to export to two spreadsheets corresponding to each sales person.

The first spreadsheet will look like the following:
salesid businesschannel custid amt
001 A XXX 2000
001 A YYY 3000
and the file name for excel will be 001_A.xls where 001 is the salesid and
A is the businesschannel.

Similarly the other spreadsheet will be as following:
salesid businesschannel custid amt

002 A TTT 5000
002 A KKK 1000

and the file name for the excel will be 002_A.xls with the same meaning. I
need to have this through loop so that this applies to more than 50 sales
person.
I am new in excel. I appreciate any help for resolution of this issue. Thanks.