I'm looking for help on the best way to compare two
different spreadsheets (in different workbooks). Each
spreadsheet is a report of open receivables.

Workbook 1 is last week's report with notes. Workbook 2
is this week's report without notes.

If an item exists in both workbooks, I want to copy the
notes from Workbook 1 and put them in workbook 2 (so the
user doesn't have to research the item all over again).

Not sure if 2 arrays should be (or can be used) and or how
to compare fields in both arrays to find the same item.

I could read a cell in Workbook 1 and then see if it
exists in Workbook 2 but then I would be taking each item
in Workbook 1 and reading thru Workbook 2. That doesn't
seen very efficient.

I could read a cell in Workbook 1 and run thru Workbook 2
until I find a cell that is equal to or greater than the
same key field in Workbook 2.

I'm just wondering if there is an easier, better, or more
efficient way to accomplish this. Any suggestions would
be great. Thank you for the help....