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.
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.
Anyone?
'ppreciate it.
- 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.