Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Handling in Excel for Mac | Excel Programming | |||
File Handling | Excel Programming | |||
handling the print to file prompt | Excel Programming | |||
file handling 2 | Excel Programming | |||
file handling | Excel Programming |