multiple find and replace

A

Andre

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
 
S

Sean Timmons

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/ move selected data from workbooks to seperate worksheets or workbooks 1
Create different workbooks from workbooks 3
Work laptop issues 4
IF Formula and multiple formulas 1
SUM with two conditions 4
Formula for Ratios 1
Copy/Paste without changing location references 2
IF function? Moving the same info from one worksheet to another. 3

Top