Hi Folks,
Im trying to link the range B47 to B60 from 18 separate tabs within an excel workbook into separate pages within a word document.
ie. tab 1 range B47 to B60 into page one of my word doc, Tab 2 range B47 to B60 into page 2 of my word doc and so on.
Can it be done.
Thanks in advance.
Brian
Last edited by singerbatfink; 01-21-2011 at 04:14 AM.
Hello Brian
Yes it should be. The approach with vary slightly according to which combination of Excel and Word you are using:
- In Excel, select the cells and Copy
- In Word, Edit | Past Special | Paste Link | Unformatted Text.
David
Access and Excel Developer | UK
Hi David,
Thats excellent, thanks for your help.
Brian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks