Getting the different columns of data into the same calculation column is relatively easy, using the OFFSET function, or perhaps the INDEX function.
Getting the results back into two separate columns is probably imposible.
Why can't you simply copy the calculation function from Column A to Column B thus (in your example) Calculation B2 becomes:
=Data!B2*Data!B2
Results B2 then becomes:
=Calculation!B2
Mark.
Bookmarks