View Single Post
  #3   Report Post  
Joe K
Posts: n/a

On Mon, 07 Feb 2005 18:52:12 GMT, (Joe K) wrote:

Is there a way to select a group of cells and then copy their
respective references to a new location so the cells at the new
location reference the original cells?

For instance, assume I have data in locations A1 to A4 and B1 to B4.
If I select those eight cells, I'd like to paste the references to
those cells (i.e., A1, B1, A2, B2, etc.) into a new location, for
instance starting at E10, without manually typing in the references
individually. When done, E10 would contain reference to A1 (=A1), E11
would contain reference to A2 (=A2), etc.

Joe K.

Duh!! I think I found the answer to my question. Select, copy, paste
special, paste link seems to do the trick. Sorry for the original

Joe K.