hi guys,
I am looking for a way to accomplish this:

I have 2 spreadsheets A and B.

A is a multi-sheet workbook.

For each of the values in a specified column in the second sheet of
workbook A, I need to find if the value is present in spreadsheet B
and if yes display the matching row.

Ideally I'm hoping it can be done w/o opening either spreadsheet but
if I must open Spreadsheet A to the right sheet and execute from
there, that's fine.

Any ideas?

I have good programming skills though not in VBA (which I assume might
be the tool to use here?)

Thanks!