I need more information.

1) Do the workbook have the same data in the same rows?

2) Are there more rows in one sheet than the other?

3) What makes the rows unique (is comparing the name and address will be
unique or can the same address and name have more than one row)?

You can either do this with a worksheet function or a macro depending on
your answers above.
"carlson120800" wrote:

I have 2 worksheets (in the same workbook). Both worksheets contain much of
the same information, however, some columns have been updated (changed from
unpaid to paid, add a check number, deposit date...) I would like to
consolidate this information without duplicating data. Is this possible?
See Example:

Sheet 1
Name Address Paid Check # Deposit Date
Bob 123 1st o

Sheet 2
Name Address Paid Check # Deposit Date
Bob 123 1st x 456 6/6/08