Sheet 1 contains following data
find Replace with
krw usd
jpy usd
aud cad
gbp euro

Sheet 2 contains whole range of data with words to find located at different
rows/coulums.
Is there any formula/vb code wherein it can find above words and replace
with mentioned words against it.

rgds


--
rgds