linking whole rows of cells

F

fxcel

Hi folks,

How can I easily link all of the cells in a row to all of the cells in
a row in another workbook without having to individually create each
link?

TIA!
 
M

Mangesh Yadav

In A2 enter
=A1
and copy across till the number of columns is reached.

Mangesh
 
Top