R
rbmcc
I want to replace all instances of a set of values (A1-A81) with th
values and formating in the corrisponding cells in column B (B1-B81).
I need a macro that will search all cells (except for columns A and B
and replace as discribed above.
i.e. if cell A1=Tom and B1= *_Poe,_Tom_*
Any instance of Tom will be changed to *_Poe,_Tom_*
So on and so forth.
If possibly storing the search/replace parameters on a different shee
would be easier, that is an option for me as well.
This is in Excel 2000.
If this isn't possible, how could I write a macro that finds a value
changes that value, then applies formatting? (so that I can manuall
enter all 81 values to accomplish the same thing).
Thanks,
Rus
values and formating in the corrisponding cells in column B (B1-B81).
I need a macro that will search all cells (except for columns A and B
and replace as discribed above.
i.e. if cell A1=Tom and B1= *_Poe,_Tom_*
Any instance of Tom will be changed to *_Poe,_Tom_*
So on and so forth.
If possibly storing the search/replace parameters on a different shee
would be easier, that is an option for me as well.
This is in Excel 2000.
If this isn't possible, how could I write a macro that finds a value
changes that value, then applies formatting? (so that I can manuall
enter all 81 values to accomplish the same thing).
Thanks,
Rus