Select all the worksheets that have the formula that you want to change. Go to BH7 and change the formula. The formula has now been changed in all the selected worksheets. Right click on the worksheet tabs and choose Ungroup and all the worksheets will become separate once again.
Whatever you do to one of the grouped worksheets is done to all of the grouped worksheets.
If the worksheets are placed together, click on the first one, hold down the shift key and click on the last one then all the worksheets will be grouped. If you have only the 93 worksheets in the workbook, right click on a worksheet tab and click on Select All Sheets which will do the same grouping of all the worksheets.
Bookmarks