When you copy and paste link multiple cells, the formulas generated look like this:
=Sheet1!A1
=Sheet1!A2
=Sheet1!A3
.
.
However, if you copy and paste link a single cell, you get this:
=Sheet1!$A$1
This creates a lot of problems if you forget to remove the $ symbols before copying to an adjactent column!
Is there any way to kep Excel from putting in the $ characters?
Thanks,
Mark
Bookmarks