Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2012, 11:28 PM
tkondaks tkondaks is offline Doing a linked paste within a linked spreadsheet Windows 7 32bit Doing a linked paste within a linked spreadsheet Office 2010 32bit
Novice
Doing a linked paste within a linked spreadsheet
 
Join Date: Aug 2012
Posts: 4
tkondaks is on a distinguished road
Default Doing a linked paste within a linked spreadsheet

I get a lot of benefit from being able to do pastes of links of arrays of cells from spreadsheets into Word.

However, I have had occasion when I have link-pasted an array of cells from a spreadsheet into word that in another part of the same word document I would like to link-paste a SMALLER section within the same array of cells onto the same document.

Example: I have link-pasted a series of figures found at A1:C5 on my spreadsheet into chapter 1 of my word document. In chapter 2, I want to link-paste the contents of cell B3 into a sentence I'm writing there.



Can this be done?
Reply With Quote
  #2  
Old 08-17-2012, 12:23 AM
macropod's Avatar
macropod macropod is offline Doing a linked paste within a linked spreadsheet Windows 7 64bit Doing a linked paste within a linked spreadsheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,617
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi tkondaks,

You would do that by copying B3 from Excel and pasting a new link into Word. You can't directly reference part of a linked object.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
linked cells msheyworth Excel 5 04-03-2012 03:12 PM
Doing a linked paste within a linked spreadsheet listing linked graphics eng1ne Drawing and Graphics 5 02-28-2012 06:42 AM
Linked graphics eNGiNe Word 2 02-20-2012 10:52 PM
Linked Tables afpapa2 PowerPoint 0 12-01-2011 09:25 AM
Doing a linked paste within a linked spreadsheet making 2 files that are linked. glda19 Word 1 04-05-2011 03:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft