Thread: Can you copy & paste cells across worksheets and preserve reference to worksheet?
View Single Post
 
Old 11-26-2013, 11:36 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
If you use cut & paste, instead of copy & paste, that will preserve sheet references in the formulae. Of course, that's a bit of a limitation if you want to retain the original - which case, simply copy & paste it back from the destination to the source! Now your formula on the source sheet will have their sheet references too, which means from now on you can copy & paste.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote