Using Excel 2003.
I want to replace old item names with new ones. Sheet 1(has old names): A2= Dog; A3= Cat, A4 = Bird. Sheet 2 (has new names): A2= Doggy; A3= Cat, A4 = Birdy. I would like to rename everything in Sheet 1 with new name but not all cells would be effected. And this needs to be dynamic because next weeks Sheet 1 might be A2 = Horse; A3= Dog; A4 = Frog.
Thanks for your help>
I want to replace old item names with new ones. Sheet 1(has old names): A2= Dog; A3= Cat, A4 = Bird. Sheet 2 (has new names): A2= Doggy; A3= Cat, A4 = Birdy. I would like to rename everything in Sheet 1 with new name but not all cells would be effected. And this needs to be dynamic because next weeks Sheet 1 might be A2 = Horse; A3= Dog; A4 = Frog.
Thanks for your help>