ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   Expanding links??? (https://www.excelbanter.com/links-linking-excel/105221-expanding-links.html)

POD {Ò¿Ó}

Expanding links???
 
Hello folks,

I need to link from data in Excel into Word, however, I need to be able to
show various lines of data in the link, so sometimes there maybe 10 lines
of Data in the Excel spreadsheet, but other times there maybe 15 lines of
data.

What seems to be the case is, when you create the link, it is cell
specific, so you link to A1:D14.

So is there a way I can show 10 lines of Excel data then if I add more data
to the spreadsheet, it will show up in the word link???

--
Thank you kindly

POD {Ò¿Ó}
¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸¸ .·´¯`·.¸
Oh people, know that you have committed great sins.
If you ask me what proof I have for these words,
I say it is because I am the punishment of God.
If you had not committed great sins,
God would not have sent a punishment like me upon you.
¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸.·´¯`·.¸¸ .·´¯`·.¸


Bill Manville

Expanding links???
 
Linking to a named range would seem a possible answer, but I suspect
that the size of the picture of the range in Word will not change, even
if more rows of data are available through it.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup



All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com