Link spreadsheets

[Kelly]

I am trying to link spreadsheets to receive data from one another from
certain columns?

[Tom Ogilvy]

With both workbooks open in a cell in row1 of the book not named MyBook.xls

='[MyBook.xls]Sheet1'!C1

then drag down the column as an example.



--
Regards,
Tom Ogilvy


"Kelly" <[email protected]> wrote in message
news:[email protected]...
> I am trying to link spreadsheets to receive data from one another from
> certain columns?