WorkSheet reference
Is sheet name a must in the formula ? If not remove it and then copy the
fomula to other sheets ( I hope I have understood your requirements
properly).
"lena_form" wrote:
Hello,
It worked perfectly.
Thank you a lot
--
HC
"driller" escreveu:
assumed as...
When i copy the formula for the next rows or columns, i want the reference
of the sheet change (sheet3;sheet4;...)
maybe like this
on one sheet location along row(2) say e.g. sheet2!Z2
=SUMIF(INDIRECT("Sheet"&ROW()&"!$f:$f"),"Total
Rota:",INDIRECT("Sheet"&ROW()&"!$h:$h"))
---copy down you will have the sumif for sheet3, sheet4,
consecutively...Ref# will appear denoting that there is no sheet"n" in the
workbook.
regards,
driller
--
*****
birds of the same feather flock together..
"lena_form" wrote:
I need to create a formula that change the reference of a sheet when i copy
the formula.
I have the formula: sumif(sheet2!$F:$F;"Total Rota:";sheet2!$H$H)
When i copy the formula for the next rows or columns, i want the reference
of the sheet change (sheet3;sheet4;...)
(Sorry my english) :)
Thank you
--
HC
|