I am looking for a way to do the following:

If ("d1:d999") = "text in the cell" then copy ("e1:e999") to ("f1:f999")

In other words I have a standard text like "tax" in d3, d18, d44, etc. If this text exsists then I want to copy e3, e18, e44, etc. to f3, f18, f44.

If this possible?

Thanks,

Met