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

Why not get the 'main office' to send you the data in an Excel workbook or, failing that, as a Word table? Evidently they're getting it from somewhere in order to send it to you.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thnks for answering. I thing they are getting it from some odd ledger system that they have had for years. It's worth asking. I would rater have in access format but excel will to
Dick

If they can supply the data in a comma-delimited format (csv), you could easily import the data into Excel or Access.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]