Hi all,
*
I´ve made the formula below for a weekly followup worksheet, the formula is therefor present in 52 sheets and I need to remove the "week part" from the formula. Thing is I have from week 1 to week 52, the rest of the formula is the same.
*
how do I remove the highlighted part without having to go through all 52 sheets?
*
=(IF(F7="";0;F7-E7)+IF(F9="";0;F9-E9)+IF(F11="";0;F11-E11)+IF(F13="";0;F13-E13)+IF(F15="";0;F15-E15)+IF(F17="";0;F17-E17)+IF(F19="";0;F19-E19)+IF(F21="";0;F21-E21))-'week 1'!K6
*
Thanks in advance!
xlsmNewbie