ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display text source in multiple sheets (https://www.excelbanter.com/excel-worksheet-functions/238215-display-text-source-multiple-sheets.html)

Nic Daniels

Display text source in multiple sheets
 
Hi,

I'd like to display a text box in numerous sheets in an Excel file by using
only one source file (preferably Word). I tried to insert an object --
'Create from file' but the text box doesn't update as I edit the source file.
Any suggestions?

Thanks!


--
Kind regards, Nic

Luke M

Display text source in multiple sheets
 
Perhaps the easier way would be to have a single cell somewhere linked to
Word, and then have all your text boxes link to that cell.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Nic Daniels" wrote:

Hi,

I'd like to display a text box in numerous sheets in an Excel file by using
only one source file (preferably Word). I tried to insert an object --
'Create from file' but the text box doesn't update as I edit the source file.
Any suggestions?

Thanks!


--
Kind regards, Nic



All times are GMT +1. The time now is 01:28 AM.

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