Quote:
Originally Posted by macropod
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.
|
That's a roundabout way of doing it, but as long as it works! Thanks!