dpatel
07-28-2010, 06:22 AM
Hello,
Hope some one can help me. I have also attached the sample workbook.
I have got no. of data with multiple values in a one column (Industries) but i would like to set up a macro to find specific text value.
If excel find sepecific text vaule then create a new column(first instance only) and start replacing the vaule with unique text vaule (Replacement values will be fix by user.) and it will loop until end of last row.
Thanks in advance!
Hope some one can help me. I have also attached the sample workbook.
I have got no. of data with multiple values in a one column (Industries) but i would like to set up a macro to find specific text value.
If excel find sepecific text vaule then create a new column(first instance only) and start replacing the vaule with unique text vaule (Replacement values will be fix by user.) and it will loop until end of last row.
Thanks in advance!