Terry can you post the code you use for Automation? Did you keep Operator and route code in Excel Sheet? I ask you becuase Excel has wonderful function called Subtotal.


>Hi Hilmar
>
>Forgive me for approaching you direct but I'm so tired now and I need to get this done before goiig on holiday. As you can see, Sergey's already given me some advice but, as you're the excel auto guru (:-) I thought of going straight to you, just in case you haven't noticed this post.
>
>Cheers
>
>Terry
>
>>>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.
>
>OK
>
>3) I need to sub-total and total some columns. Is there a way to automate that?
>
>Sad because the cursor fits my report, and in the report I've used report vars for the totals, now it seems I need to do it all again in the s/s.
>
>4) Nice to slot a heading row in saying what dates etc.
>
>Tired, so very tired now ....