|The formulas are about 4,000-6,000 characters in about 500+ cells with links throughout the 10 worksheeets. The issue I have is that I need to now delete one of those worksheets (that line of business is now no longer offered) and thus everywhere it is linked throughout my roll up 11th worksheet.|
I tried to crtl-H change from - to but the addition of the cell reference makes that attempt moot. I also tried to shorten the "from" in Ctrl-h without the cell reference and add a * then change the cell to 0 but it changes all my formula after the reference in found to 0 not just that worksheet reference.
I could rewrite all the formulas for all cells but that will take weeks and then you have the issue of mistakes and verification.
There has to be a command that can find and eliminate a reference to another worksheet without using the cell designator so that I can make that a 0 value.
Your suggestion of making the unused worksheet a 0 value sounds good but the reports are pulled from the system and thus that worksheet will not exist any longer. Also this may happen again so trying to learn a better way than recreating the roll-up.