vertically match up 2 sets of data

J

jeremy

I am wondering how to get one set of data to vertically
match up to another:
What we have is a weekly AR report with column A as the
customer name. Let's say column E is comments that we
enter.
The next week, we run the report ( which will have alot of
the same customers in column A, with some additions and
some deletions.) I need to find a way to have this new
report look for the same customer name in the old report
and copy the comments in column E to the new report.

Any ideas?
Help is much appreciated :)
 
Top