View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lena_form lena_form is offline
external usenet poster
 
Posts: 8
Default WorkSheet reference

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