It's hard to figure out what might work for you given the vagueness of your
question. Perhaps you can explain a little more clearly what you want to
accomplish.

What do you mean by 'compare' and 'records?'
How is the data set up in each workbook?


"JerryCLT" wrote:

Is there a way for me to use VLOOKUP (or another function) to be able to
compare records in one workbook with only one sheet (master workbook 1.xls)
to another workbook (slave workbook 1.xls) which has multiple worksheets
without cutting and pasting the multiple worksheets in the later all into one
sheet?

Thanks so much if you have an answer.

Jerry