ExcelBanter - Link spreadsheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Link spreadsheets (https://www.excelbanter.com/excel-programming/354933-link-spreadsheets.html)

Kelly

Link spreadsheets

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

Tom Ogilvy

Link spreadsheets

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" wrote in message
...
I am trying to link spreadsheets to receive data from one another from
certain columns?

All times are GMT +1. The time now is 10:31 AM.