Directly referencing multiple cells
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. In article , "Link" wrote: 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. |
Directly referencing multiple cells
Another way would be to copy the cells, then paste special and select paste
link in the other sheet -- Regards, Peo Sjoblom "Link" wrote in message ... 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. |
Directly referencing multiple cells
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. |
Directly referencing multiple cells
=Sheet1!A1 can be copied down to give =Sheet1!A2, =Sheet1!A3, etc
etc........... Vaya con Dios, Chuck, CABGx3 "Link" wrote in message ... 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. |
Directly referencing multiple cells
This worked perfectly - thank you!
Cheers, Link. "JE McGimpsey" wrote in message ... 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. In article , "Link" wrote: 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. |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com