Forum Discussion
Search and Replace
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!
Casper
You may select all the worksheet (press ctrl when selecting worksheets) and then type the formula in one of the sheets. Then the other sheets will have the same formula. Remember to "ungroup" the worksheet by right click the sheet-tab at the bottom.
2 Replies
You may select all the worksheet (press ctrl when selecting worksheets) and then type the formula in one of the sheets. Then the other sheets will have the same formula. Remember to "ungroup" the worksheet by right click the sheet-tab at the bottom.
Thank you very much! That saved me some hours of work since I had 19 other formulas to change the same way.
