Hi All
I have a puzzle. In my documents I sometimes have to paste variable text where there are some duplicated lines.
The amount of duplicated lines varies too , but they do all follow the same pattern and each is followed by a reference number.
Each time these lines are inversions of the lines I need to keep.
I'm trying to delete the first of any duplicated lines.
for example
JOYCE SIMS - COME INTO MY LIFE
97757BX93
HELP - BEATLES THE
THE BEATLES - HELP
111322BX35
MANDY - BARRY MANILOW
BARRY MANILOW - MANDY
113720BX89
Would become
JOYCE SIMS - COME INTO MY LIFE
97757BX93
THE BEATLES - HELP
111322BX35
BARRY MANILOW - MANDY
113720BX89
Can someone see a way to do this , and suggest some VBA?
Grateful for any help.
Bookmarks