We have a fairly large amount of data that must be sifted through monthly to
create some of our financial reports. We need to combine sales data for each
item this year with sales data for each item last year. This years data
comes from a pivot table that accesses the database. To work with the values
we copy and paste the data into a new workbook. Last years data is saved in
another workbook. Complicating matters is the fact that since last year we
have started selling some new lines and have gotten rid of some oldones.
Thus the product lines won't match perfectly. We need to bring last years
data into this year and have it put itself in the column we specify while
matching itself to rows that allready exist, skipping rows that don't exist
in last years data, and creating rows for lines that existed last year but
not this year. I appreciate all your help on this matter. Thank you all for
you time.

Jesse