Can you copy & paste cells across worksheets and preserve reference to worksheet?



I have multiple analysis across multiple worksheets, but want to bring them all together and create a single big tabulation. But when I copy & paste the tables from one worksheet to another, I get an error because some formulas are now off, unless they refer to their original worksheet. Is there any way to convert the formulas so as to include a reference to the original worksheet when I copy & paste data from one worksheet to another?

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]

That's a roundabout way of doing it, but as long as it works! Thanks!