Klartigue
09-01-2011, 06:10 AM
A1 BMO Capital Markets
Cover Wells Fargo
A2 UBS Financial Svc
Cover Morgan Stanley
A3 Southwest Securities
Cover Piper Jaffray
etc..
In column M of my spreadsheet, the names of brokerage firms are listed as above. I have another spreadsheet called the settlement sheet located at G:\Katherine Lartigue\Instructions that contains all of the broker contact and phone numbers. How would I write a macro that looks at the brokers only for A1, A2, A3, etcc.., finds that broker contact name and number (listed in column F of the settlement sheet) on the settlement sheet, and copy and paste that phone number in column U of my main sheet?
Thanks for the help.
Cover Wells Fargo
A2 UBS Financial Svc
Cover Morgan Stanley
A3 Southwest Securities
Cover Piper Jaffray
etc..
In column M of my spreadsheet, the names of brokerage firms are listed as above. I have another spreadsheet called the settlement sheet located at G:\Katherine Lartigue\Instructions that contains all of the broker contact and phone numbers. How would I write a macro that looks at the brokers only for A1, A2, A3, etcc.., finds that broker contact name and number (listed in column F of the settlement sheet) on the settlement sheet, and copy and paste that phone number in column U of my main sheet?
Thanks for the help.