R
Roberta Fischer
Hello,
I'm having a problem copying worksheet links. (My words may be wierd, I'm
used to working in a German Version)
I have one overview sheet that is connected to data sheets. These data
sheets have data in them to determine the level of environmental risk at a
particular location. Numerous cells from these data sheets are to be linked
to the overview sheet at the beginning (e.g. name of site, environmental
risk, technical risk, etc.)
I've come so far that the first three data sheets are properly connected to
the overview sheet, example: ='1'!$A$2
However, when I try to copy this formula to put it into other cells it
either pastes the exact same formula (not changing the '1' to a '2', etc) or
if I use the control key, it opens a window where I should choose another
file to link to.
How can I paste this formula so the '1' changes to a '2', or '3', or whatever?
Thanks for the help,
Roberta
I'm having a problem copying worksheet links. (My words may be wierd, I'm
used to working in a German Version)
I have one overview sheet that is connected to data sheets. These data
sheets have data in them to determine the level of environmental risk at a
particular location. Numerous cells from these data sheets are to be linked
to the overview sheet at the beginning (e.g. name of site, environmental
risk, technical risk, etc.)
I've come so far that the first three data sheets are properly connected to
the overview sheet, example: ='1'!$A$2
However, when I try to copy this formula to put it into other cells it
either pastes the exact same formula (not changing the '1' to a '2', etc) or
if I use the control key, it opens a window where I should choose another
file to link to.
How can I paste this formula so the '1' changes to a '2', or '3', or whatever?
Thanks for the help,
Roberta