Find/Replace in a selected cell(s), but across entire workbook

[ue418]

Hello. I have 90 sheets, each with a "=sheet91!$L$x" formula, where on sheet 1, x is 1, on sheet 50, x is 50, etc. In other words, sheet91 has a column ("L") of data, from row 1 to 90, that this cell is "sequentially" referencing. Each successive sheet is referencing the next row on sheet91. But...I've added another column ("M") on sheet 91, which I want another cell on each sheet to similarly reference. So I quickly grouped all sheets (1 thru 90) and copied/pasted the cell contents to a different cell...But of course its formula still says "...!$L$x" . My new column on sht 91 is column M, so I need to change all those cells' (90 occurrences) formulas from "L" to "M". I grouped the 90 sheets, clicked that cell and tried find replace all, but that changes ALL cells that have a "$L", not just those in the designated cell. That would be okay if I didn't have other cells (namely, the one I copied and pasted from) on each sheet that have the "sheet91!$L$..." reference. Is there not a way to find/replace across sheets, but also for a designated cell only?? Thank you so much for reading (and hopefully following this).



Rick