multiple find and replace
 

I have a worksheet with long formulas pasted from a database. Some of these
ratios, i would like to replace. however, the sheet is 22,000 rows in length.
I have around 350 ratios that I have in a seperate worksheet(column A),
which I would like to replace with a different 350 ratios from the last
mentioned sheet (column B).

Therefore in 22,000 lines, I would like to replace 350 ratios inside this
22,000 lines, with another specific ratio, which is in a table.

Tricky one

multiple find and replace
 

That would depend on what the ratios look like... you can do a Find/Replace,
but we'd need to know what you're replacing and where it would be. Could you
provide one of the formulas in a post, along with a sample of a few lines
from the new table?

"Andre" wrote:

I have a worksheet with long formulas pasted from a database. Some of these
ratios, i would like to replace. however, the sheet is 22,000 rows in length.
I have around 350 ratios that I have in a seperate worksheet(column A),
which I would like to replace with a different 350 ratios from the last
mentioned sheet (column B).

Therefore in 22,000 lines, I would like to replace 350 ratios inside this
22,000 lines, with another specific ratio, which is in a table.

Tricky one