Thanks for reading this post.

I have two files named X and Y. I want to link column A in file X sheet 1 to
row 1 in file Y sheet 2. eg. File X sheet 1 cell A1 should be linker to file
Y sheet 2 cell P10; File X sheet 1 cell A2 to be linked to file Y sheet 2
cell Q10, similarly cell A3 to cell R10 and so on. How can this be done
easily without linking the cells individually? linking columns to columns or
row to row is simple, just enter the formula in one cell and drag it down or
across as required. Is there any such trick to link a column to a row as
explained above?

Preman