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>
