MikeBerlan
New Member
- Joined
- Aug 20, 2016
- Messages
- 7
I have approximately 1800 agent data files in column B and need to sequentially copy the email addresses into column C. Note: the cell including the email address...E-Mail: jack@abcrealty.com[/B]...etc do not fall on every 8th row because each data file is different. Can someone help with an Excel Formula that can solve my problem?
Column B Column C
Example: John Smith jack@abcrealty.com
ABC Realty nancy@abcrealty.com
123 Adams Street
Jacksonville, FL 01234
Agent
Cell Phone: 123-45-6789
Home Phone: 123-45-6789
Website: www.sellingyourhome.com
E-mail: jack@abcrealty.com
Nancy Smith
ABC Realty
123 Eve Street
Jacksonville, FL 01234
Broker
Cell Phone: 123-45-6789
E-mail: nancy@abcrealty.com
Column B Column C
Example: John Smith jack@abcrealty.com
ABC Realty nancy@abcrealty.com
123 Adams Street
Jacksonville, FL 01234
Agent
Cell Phone: 123-45-6789
Home Phone: 123-45-6789
Website: www.sellingyourhome.com
E-mail: jack@abcrealty.com
Nancy Smith
ABC Realty
123 Eve Street
Jacksonville, FL 01234
Broker
Cell Phone: 123-45-6789
E-mail: nancy@abcrealty.com