How to delete one of the sheets with all related formulas

[M Sleem]

I have sheet (A) receiving values from sheet (B) & I want to remove sheet (B) with all related formulas in sheet (A) e.g.

Sheet (A) include: if (sheet (A) cell (x)=y, sheet (B) cell (z),"")

So i want to remove the whole [value_if_true] & deleting sheet (B)

Thanks in advance!

[Richard Buttrey]

Hi,

Not sure exactly what you want to end up with.
Maybe you could convert all these formulae to values if you want to retain the values, or use Find & replace to find the sheet B references in the formula and change to whatever the new True condition should be.