software

Hi All,

In excel I have 2 sheets (Sheet1 amp; Sheet2), in the same
workbook(Book1.xls). Sheet2 is refering to Sheet1 to get values in
different cells in Sheet2.
I want for example, whever there's a text * XYZ * in sheet2, replace
that text with * W1P * in Sheet2.
I have like 20 kind of text that on any cell found need to be replace
by some other 20 text. This I want to accomplish on Sheet2

I have no clue about VBA/Macros.
I dont want to find/replace, since I have many many sheets amp; it will be
time consuming.
How can I achieve this?.
Whats the quickest amp; easiest way to do it?.

Any help would be appreciated.

Thanks,--
zeeshan13
------------------------------------------------------------------------
zeeshan13's Profile: www.excelforum.com/member.php...oamp;userid=32911
View this thread: www.excelforum.com/showthread...hreadid=527329Please don't post in more than one group

--
Don Guillett
SalesAid Software

quot;zeeshan13quot; gt; wrote
in message ...
gt;
gt; Hi All,
gt;
gt; In excel I have 2 sheets (Sheet1 amp; Sheet2), in the same
gt; workbook(Book1.xls). Sheet2 is refering to Sheet1 to get values in
gt; different cells in Sheet2.
gt; I want for example, whever there's a text * XYZ * in sheet2, replace
gt; that text with * W1P * in Sheet2.
gt; I have like 20 kind of text that on any cell found need to be replace
gt; by some other 20 text. This I want to accomplish on Sheet2
gt;
gt; I have no clue about VBA/Macros.
gt; I dont want to find/replace, since I have many many sheets amp; it will be
gt; time consuming.
gt; How can I achieve this?.
gt; Whats the quickest amp; easiest way to do it?.
gt;
gt; Any help would be appreciated.
gt;
gt; Thanks,
gt;
gt;
gt; --
gt; zeeshan13
gt; ------------------------------------------------------------------------
gt; zeeshan13's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32911
gt; View this thread: www.excelforum.com/showthread...hreadid=527329
gt;