Thanks for the help, but I misstated my earlier question/example. Here's
what I really want to accomplish.
On Sheet A, cells a1:cv100, I want to reference the values from Sheet B,
cells b2:b101. Is there an easy way to accomplish this? On a related note,
I will want to sort the data on Sheet A without disturbing the references
Sheet B.