Copy formula
Just copy & paste the formula as you have described, then change the 3
instances of Wk1 to Wk2
--
Please remember to indicate when the post is answered so others can benefit
from it later.
"Kim" wrote:
I want to copy a formula from one cell to another but need the sheet
reference to change from "sheet 1" to "sheet 2" in the formula:
Example = SUMIFS('[WKLY YR06.xlsx]Wk1'!$C$2:$C$5000,'[WKLY YR06.xlsx]
Wk1'!$E$2:$E$5000,"TF5",'[WKLY YR06.xlsx]Wk1'!$D$2:$D$5000,"600020")
This formula is in cell C4, I want to copy to D4 and I want everything
to stay the same but go to the next sheet (same place in the sheet).
Can anyone help me???
Kim
.
|