Hi all,

I have 2 workbooks, lets say they are workbook1 and workbook2.

In workbook1 I have several thousand rows like so:

A1 Product - B1 Price | C1 Product - D1 Price | E1 Product - F1 Price etc
A2 Product - B2 Price | C2 Product - D2 Price | E2 Product - F2 Price etc
A3 Product - B3 Price | C3 Product - D3 Price | E3 Product - F3 Price etc
And so on (There may be several worksheets but all are the same layout as above)

In workbook2 (worksheet 1) only in column A I have a list of products, nothing else, no prices in column B.

Is there a way to grab the prices from workbook1 regardless of which worksheet they are in and copy/paste the corresponding price into the column B cell adjacent to the product in workbook2?

Alternatively, if this is a bit difficult I can always add an extra worksheet to workbook1 and have my list of products in column A in that worksheet, thus eliminating the need to copy from one workbook to another.

Thanks for any help on this, it is really not feasible to do a 'find' / copy and paste for this.