Exporting to EXCEL into multiple worksheets 1

[ldalessio]

I have created a Crystal report listing based on three education courses and the students enrolled in those courses. The report exports to EXCEL with no problem into one worksheet. Is there a way I can export that list into three worksheets based on the course?
Thanks for the help.

 

[lbass]

You need third-party software (inexpensive) to do bursting like this. See

http://www.milletsoftware.com

for Visual Cut or check out Ken Hamady's site

http://www.kenhamady.com

for his list and review of software options.

-LB

 

[SkipVought]

Hi,

Why not export to one sheet and let Excel's AutoFilter display whatever course is selected, as long as the course values are displayed in one column on each row?

If it were me, I would MUCH prefer ONE sheet than multiple sheets containing similar data.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}