Each month I get a word doc from the main office. It has:

date, amount, running total, giver, add, city, state.
memo thank you
date, amount, running total, giver, add, city, state.
memo thank you etc.


as many as 29 record.

At the present I copy and paste in workbook
I then have to go in and delete all the memo thank you lines.

I then cut and paste the giver into the first column
next I do an atoZ sort on the giver/name. Then Print
Lots of work. Is there a better way?
Thanks Dick