>>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 (:-)...
>
>Not really, although I did write an introductory article. I would say, Tamar is the Automation guro.
Yes I had your doc, but on my home pc from when I worked at home, and it was very helpful
>
> I thought of going straight to you, just in case you haven't noticed this post.
>
>Can you give the number of the original thread?
Doesn't realluy matter - it's all below, so far.
>
>>>>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
>>
>>I need to sub-total and total some columns. Is there a way to automate that?
>
>I usually use the sum() formula for this. Did you try saving a macro with Excel, creating the formula, and looking at the resulting VBA code?
>
>It is not quite clear to me, in this message, what you have already achieved, and what you are missing.
I've done as far as exporting the table to excel. I know, from your intro, how to rename cells (e.g. to give better column headings) but I need 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.
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 as poss.
3) provide totals at route, operator and grand levels
4) slot in an extra row, at top, with a heading.
Cheers
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.