Hello,

I'm using excel 97 and I want to save paper with my prints...so I need
your help :)
I'm importing into excel a couple of lines (this may vary day by day.)
there I copy by a simple macro a vertical lookup function an action I
have to perform by each rule.
due to some technical issue I receive double and triple lines (even
four lines if I'm lucky).
I have to print this report so it would be nice if a macro could
automaticly remove lines untill a line is unique.

so by example.
A B C D E
1 28-12-2006 51803 6511927 Nogueira & Barroco Lda Faxen
2 28-12-2006 51803 6511927 Nogueira & Barroco Lda Faxen
3 28-12-2006 51803 6511927 Nogueira & Barroco Lda Faxen

They are always grouped but I want to remove (not hide) the 2 or three
lines
In one sheet a hundred ore more lines are like this

Could any one help?
If I'm not clear please also tell me and I'll try to clear things.

Thnx Jerry