Hello,
i have a project where i am pretty sure i need VBA but i am in the process of learning. basically i have about 20,000 rows of datas and text and i have how it is formated below. if there is more then one e-mail address in column B(which can be sepearted by either a space,comma,or semicolon) then i need to insert a new row directly below the original for each e-mail address. and in the new row all information needs copied from all cells in original row except the e-mail which obviously will be the new e-mail. so i am tryiong to create coding to run that will recognize that there needs to be a new row for all the e-mail addresses in the original cell. any advice would help because i am racking my brain. thank you
Before:
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
i have a project where i am pretty sure i need VBA but i am in the process of learning. basically i have about 20,000 rows of datas and text and i have how it is formated below. if there is more then one e-mail address in column B(which can be sepearted by either a space,comma,or semicolon) then i need to insert a new row directly below the original for each e-mail address. and in the new row all information needs copied from all cells in original row except the e-mail which obviously will be the new e-mail. so i am tryiong to create coding to run that will recognize that there needs to be a new row for all the e-mail addresses in the original cell. any advice would help because i am racking my brain. thank you
Before:
Column A | Column B | Column C | Column D | Column E |
Name | e-mail1 e-mail2, e-mail3; e-mail4 | Date | Company | Location |
After: | ||||
Column A | Column B | Column C | Column D | Column E |
Name | e-mail1 | Date | Company | Location |
Name | e-mail2 | Date | Company | Location |
Name | e-mail3 | Date | Company | Location |
Name | e-mail4 | Date | Company | Location |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>