Transfering table in different excel files(not worksheets)

[gamaz]

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.


The whole transfer process including creation of files need to be done by click of a button.

I am new in excel. I appreciate any help for resolution of this issue. Thanks.

[Leith Ross]

Hello gamaz,

I think you got lost in the details.

Do this mean you have code written to export the table?

Based on the above table I need to export to excel. This part is fine.

Will there be a single workbook with 100+ sheets?

I need to export to two spreadsheets corresponding to each sales person.
I need to have this through loop so that this applies to more than 50 sales
person.

[gamaz]

Thanks for yor help. I appreciate it.
I need to export data for each of salesid to one excel file. Thus in the case we have there are two sales person. Hence there should be two excel files. So the output is not one file but different files.