>>Phew! I've just about finished my panic report. Now I've exported it to Excel. I know how to automate the s/s but I just need to know how to:
>>
>>1) remove duplicate cells' text, e.g. I don't want a column of bus operators all the same, but when the op. changes I want the name to show.
>
>I dunno if there's simple way, but you can loop through the column and blank out duplicate text. You can do that in your cursor before export.
>
>>2) reorder the columns. The cursor is not in the same L-R field order as the format of my report but I'd like to get the s/s to resemble it as much a sposs.
>
>You can run one more select before export to put columns in proper order.

Thanks Sergey. Good ideas