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?
<tbody>
</tbody>
<body id="************" style="position: absolute; top: 481px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
Column B | Column C |
John Adams | 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 | |
<tbody>
</tbody>
<body id="************" style="position: absolute; top: 481px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
John Smith Broker |
<tbody>
</tbody>