Hi,
Maybe you can post the format of both workbooks? When you say two workbooks,
is this just two worksheets is there only two worksheets involved? Maybe the
headers would be enough to work with from the worksheets?

Thanks,

"leedelee" wrote:

I need helping merging historical data with current data. The data in the
two workbooks is similar but not identical but both have a common id field.

Thanks