im sorry but i dont understand how.
i can see how i would do this for the first row.
in workbook 2 cell a1 call up workbook 1 cell a1 then in workbook 1 cell a2 call up the answer from workbook 2.
but how could i replicate this for the second row and so on??? without making a seperate workbook 2 for each row??
sorry for my ignorance but excel is not my strongpoint.
thanks
Bookmarks