#1
|
|||
|
|||
Find/Replace in a selected cell(s), but across entire workbook
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 |
#2
|
|||
|
|||
Can't you upload your project and give examples of expected results?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find/Replace using format of cell | catflap | Excel | 1 | 09-11-2017 07:28 AM |
Select Cell Text to paste into Find/Replace | CBarry | Word VBA | 2 | 02-16-2017 04:37 AM |
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color | jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
Mac Word - replace within selected text only. | bakerbj | Word | 0 | 10-31-2011 11:47 PM |
using find/replace on an entire directory? | mzimmers | Word | 0 | 12-13-2010 12:05 PM |