I am currently trying to create a macro that will look down an entire column, and if the word equals a certain word, it would then be changed to the more appropriate word.
For example, every time the animal 'Bird' was located in column B, it would be turned into the word 'Parrot'. If, while searching down column B, it came across the word 'Dog' or 'Cat', the word would remain the same.
Any help would be greatly appreciated! Thank you!!
Aucun commentaire:
Enregistrer un commentaire