J
Jack
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.
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.