Directly referencing multiple cells

[JE McGimpsey]

Assuming you want to have the references in a column on the second sheet
as well, one way:

Enter the reference for the first cell, e.g.:

=Sheet1!A1

Grab the fill handle (lower right corner of the cell) and drag down 20
cells. XL will adjust the reference.

 

[Peo Sjoblom]

Another way would be to copy the cells, then paste special and select paste
link
in the other sheet

 

[Link]

Hi All

Just another newbie question for anyone kind enough to respond:

Is there a way to reference a group of cells (eg. a column of 20 values)
directly to another group of 20 cells on a different worksheet, but within
the same file?

I know I can go to each cell and hit = (the original cell), but I have pages
of hundreds of these to do and it would take me days to do it manually.

Surely Excel must have a command that directly references these cells
automatically?

Any helpful replies will be gratefully received.

Cheers,
Link.

 

[CLR]

=Sheet1!A1 can be copied down to give =Sheet1!A2, =Sheet1!A3, etc
etc...........

Vaya con Dios,
Chuck, CABGx3

 

[Link]

This worked perfectly - thank you!

Cheers,
Link.