Hello,

Please help steer me in the correct direction.

I have one workbook with a full column of numbers.
Is there a way I can send each cell to another workbook, have it run through the various formula and equations in that workbook and them return the answer back to the adjacent cell in workbook 1.

then move onto the next row and do the same?

basically take workbook1 cell A1 > send it to workbook2 cell A1 (where it will then run through that spreadsheet to say Cell B100) then send Cell B100 back to workbook1 cell B2??
It then needs to do the exact same for cell A2 and so on.

I don't want to retain any of the numbers in Workbook 2 just use it to do the calculation.


MANY THANKS
Andy