Hello All,
Thank you for all your help in the past. I have been searching code to do this trick but I have been unable to find the solution using search and FAQs:
I get everyday a large file of about 12000 rows. Col M indicated the Project Type. Project types varies any wher from Civil, Mechanical, Chemical, etc. Each rows are identified with Project Types in Col M. Col G through Col L has addresses (name, street add, city, State, Zip, Tel #). Now, I'd like a VBA Code that replaces the addresses if the Project Type is , let's say, 'Chemical'. Then the address I'd like to see is: Micky Mouse, 123 Mickey St., Orlando, FL, 33456, 401-123-4567 (Cells in Col G thru Col L). Can any of you please help me? I appreciate it. Thank you.
Thank you for all your help in the past. I have been searching code to do this trick but I have been unable to find the solution using search and FAQs:
I get everyday a large file of about 12000 rows. Col M indicated the Project Type. Project types varies any wher from Civil, Mechanical, Chemical, etc. Each rows are identified with Project Types in Col M. Col G through Col L has addresses (name, street add, city, State, Zip, Tel #). Now, I'd like a VBA Code that replaces the addresses if the Project Type is , let's say, 'Chemical'. Then the address I'd like to see is: Micky Mouse, 123 Mickey St., Orlando, FL, 33456, 401-123-4567 (Cells in Col G thru Col L). Can any of you please help me? I appreciate it. Thank you.