Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-11-2014, 10:23 PM
macropod's Avatar
macropod macropod is offline creating mirror images Windows 7 32bit creating mirror images Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

Simply select the source range, copy, go to the destination range and paste, using the Paste Link option. From now on, any changes to the source will be reflected in the destination.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 06-12-2014, 06:24 AM
BobBridges's Avatar
BobBridges BobBridges is offline creating mirror images Windows 7 64bit creating mirror images Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

"Paste Links"? That's a new one to me.

...Oh, I guess it isn't. I mean, I'd never noticed that option before, but I see it does what I was thinking about suggesting: copies 'SHEETNAME'!RC to each cell in sheet 2.

Two issues with that method that you, gib, may not think are issues:

1) The formatting doesn't go with it. This is easily gotten around; all you have to do is paste Formats, too, a one-time operation.

2) Empty cells in sheet 1 are represented on sheet 2 as 0s. Maybe you don't care; it depends on what you want to do with sheet 2. If you do care, but only about its appearance, you can easily tell sheet 2 not to display 0 values.

3) I said there were two issues but I just noticed a third: In my test of the Paste Links operation, I happened to use a worksheet that has hyperlinks in it. They don't transfer, either. Again, whether this matters to you depends on what you want to do with sheet 2.

In fact, I see now that using this method copies only the result of a formula, nothing else about the cells: conditional formatting, width and height, they're all left on sheet 1. If you want a real mirror...

Well, I can think of two ways to do that but I'm not sure either one will be worth the cost:

1) Do what Paul said, cut-and-paste the whole range from sheet 1 to sheet 2, but paste all, not just links. The problem with this is that it isn't automatic; you have to do it every time you want sheet 2 to reflect new changes in sheet 1. I suspect you considered this already; the point of your original post is that you want a way for it to happen without you having to take manual action.

2) Write a VBA macro for sheet 1 that runs automatically; every time anything changes in sheet 1, the changed range is automatically copied to sheet 2. I've never tried that, but I imagine it would work. But it would probably slow down your work. Maybe not, though; you could try it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Would like some assistance with mirror printing jpalmisano Drawing and Graphics 1 01-08-2014 10:45 AM
save as webpage without creating new images healthyman Word 3 04-15-2012 03:51 AM
'Mirror margins' command Stuart Word 0 11-11-2011 12:16 AM
Getting 'Mirror margins' to work EXACTLY. Stuart Word 5 11-07-2011 03:49 PM
How do I mirror cells? shabbaranks Excel 2 09-13-2011 04:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.


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