VBA to change multiple company names to multiple owner names

shap

Board Regular
Joined
Jan 21, 2013
Messages
58
I'm looking to change multiple companies to the owners name instead. The script can work based on the entire row or we could specify the exact column.

I'm looking to do something like this;

if "Home Values" change to "Smith, John"
if "Costco" change to "Jackson, Michael"
etc.

Anyone help with this, please?! :eek:

Thanks in advance!

Using excel 2007.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
You'd enhance your chances of getting some help, by spending a small fraction of the time your helper will invest, to provide sufficient detail to permit code to be written for your circumstances.
 
Upvote 0
You'd enhance your chances of getting some help, by spending a small fraction of the time your helper will invest, to provide sufficient detail to permit code to be written for your circumstances.

I was hoping someone would simply ask the questions they need to know since I do not know exactly what data or details are needed to write such code. Thanks for the response. That way I don't post a bunch of useless info that increases required reading.

To explain a bit more:

Code:
[TABLE="width: 512"]
<tbody>[TR]
[TD="class: xl65, width: 64"]REO #[/TD]
[TD="class: xl66, width: 64"]City[/TD]
[TD="class: xl65, width: 64"]Address[/TD]
[TD="class: xl65, width: 64"]Designated Date[/TD]
[TD="class: xl65, width: 64"]Zip Code[/TD]
[TD="class: xl65, width: 64"]Name of Appraiser[/TD]
[TD="class: xl66, width: 64"]MSA Description[/TD]
[TD="class: xl66, width: 64"]Loan Number of Loan[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl73"]07/09/2013[/TD]
[TD="class: xl72"]85041[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl76"]GLENDALE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl77"]07/15/2013[/TD]
[TD="class: xl76"]85301[/TD]
[TD="class: xl80"]West Appraisal Group[/TD]
[TD="class: xl76"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]LAVEEN[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/08/2013[/TD]
[TD="class: xl68"]85339[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl81"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl76"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl77"]07/02/2013[/TD]
[TD="class: xl76"]85006[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl76"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/08/2013[/TD]
[TD="class: xl68"]85015[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl67"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl71"]07/09/2013[/TD]
[TD="class: xl70"]85041[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl67"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl67"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl71"]07/09/2013[/TD]
[TD="class: xl70"]85043[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl67"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/09/2013[/TD]
[TD="class: xl68"]85033[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/10/2013[/TD]
[TD="class: xl68"]85009[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl69"]BUCKEYE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl75"]07/08/2013[/TD]
[TD="class: xl74"]85396[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl69"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl76"]BUCKEYE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl77"]07/09/2013[/TD]
[TD="class: xl76"]85326[/TD]
[TD="class: xl79"]Rockstart Appraisal[/TD]
[TD="class: xl76"]Phoenix-Mesa-Glendale, AZ Metropolitan  Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]GLENDALE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/01/2013[/TD]
[TD="class: xl68"]85301[/TD]
[TD="class: xl80"]West Appraisal Group[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]GLENDALE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/11/2013[/TD]
[TD="class: xl68"]85308[/TD]
[TD="class: xl80"]West Appraisal Group[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl73"]07/31/2013[/TD]
[TD="class: xl72"]85032[/TD]
[TD="class: xl80"]West Appraisal Group[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
</tbody>[/TABLE]

In this example I would want F with header "name of appraiser" to be were the script changes names from "Rockstart Appraisal" to their owners name within the script and end result would be something like this:

Code:
[TABLE="width: 512"]
<tbody>[TR]
[TD="class: xl65, width: 64"]REO #[/TD]
[TD="class: xl66, width: 64"]City[/TD]
[TD="class: xl65, width: 64"]Address[/TD]
[TD="class: xl65, width: 64"]Designated Date[/TD]
[TD="class: xl65, width: 64"]Zip Code[/TD]
[TD="class: xl65, width: 64"]Name of Appraiser[/TD]
[TD="class: xl66, width: 64"]MSA Description[/TD]
[TD="class: xl66, width: 64"]Loan Number of Loan[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl73"]07/09/2013[/TD]
[TD="class: xl72"]85041[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl76"]GLENDALE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl77"]07/15/2013[/TD]
[TD="class: xl76"]85301[/TD]
[TD="class: xl80"]Carry, Jim[/TD]
[TD="class: xl76"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]LAVEEN[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/08/2013[/TD]
[TD="class: xl68"]85339[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl81"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl76"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl77"]07/02/2013[/TD]
[TD="class: xl76"]85006[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl76"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/08/2013[/TD]
[TD="class: xl68"]85015[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl67"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl71"]07/09/2013[/TD]
[TD="class: xl70"]85041[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl67"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl67"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl71"]07/09/2013[/TD]
[TD="class: xl70"]85043[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl67"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/09/2013[/TD]
[TD="class: xl68"]85033[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/10/2013[/TD]
[TD="class: xl68"]85009[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl69"]BUCKEYE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl75"]07/08/2013[/TD]
[TD="class: xl74"]85396[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl69"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl76"]BUCKEYE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl77"]07/09/2013[/TD]
[TD="class: xl76"]85326[/TD]
[TD="class: xl79"]Smith, John[/TD]
[TD="class: xl76"]Phoenix-Mesa-Glendale, AZ Metropolitan  Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]GLENDALE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/01/2013[/TD]
[TD="class: xl68"]85301[/TD]
[TD="class: xl80"]Carry, Jim[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]GLENDALE[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl78"]07/11/2013[/TD]
[TD="class: xl68"]85308[/TD]
[TD="class: xl80"]Carry, Jim[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
[TR]
[TD="class: xl82"]PCD783[/TD]
[TD="class: xl68"]PHOENIX[/TD]
[TD="class: xl79"]1152 E Flint St[/TD]
[TD="class: xl73"]07/31/2013[/TD]
[TD="class: xl72"]85032[/TD]
[TD="class: xl80"]Carry, Jim[/TD]
[TD="class: xl68"]Phoenix-Mesa-Glendale, AZ Metropolitan Statistical Area[/TD]
[TD="class: xl68"]16668888888[/TD]
[/TR]
</tbody>[/TABLE]

The script OR a separate file I point to would be the source of the matching.
 
Upvote 0

Forum statistics

Threads
1,213,559
Messages
6,114,302
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top