Can you link from the other workbook? Type = into the destination cell
then go to the products  workbook and click the cell you want. You'll end
up with something like ='[Products.xls]Sheet1'!$B$1. You'll need to do
it for each cell but it could be quicker than cutting and pasting. If
you need values rather than links and the intermediate cells contain
values rather than formulas, you can select the column, copy  and paste
special - values.