Forum Discussion
Solved
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 ...
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.
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.
