Cranium
02-23-2007, 10:32 AM
hey folks,
my boss wants to see if i can figure out how to automate a process in excel. basically i have one colum containing product numbers. i need the script to search for 64 specific values and then if it finds any of them, to replace them with corresponding set values.
basically i need a script that says "if any of the cells in column 'F' equal "3025" then change it to "2101" and if it equals "4046" to change it to "3108", etc etc. there is no set difference between the 2 values so i cant just do one if/then statement. i have to have 64 different cases (64 values i need to look for and change them to their corrsponding values).
can anyone clue me as how to do this? i can email you the excel file if you need it. THANK YOU!
my boss wants to see if i can figure out how to automate a process in excel. basically i have one colum containing product numbers. i need the script to search for 64 specific values and then if it finds any of them, to replace them with corresponding set values.
basically i need a script that says "if any of the cells in column 'F' equal "3025" then change it to "2101" and if it equals "4046" to change it to "3108", etc etc. there is no set difference between the 2 values so i cant just do one if/then statement. i have to have 64 different cases (64 values i need to look for and change them to their corrsponding values).
can anyone clue me as how to do this? i can email you the excel file if you need it. THANK YOU!