Transform text in cells in to table (VBA)

Dzirt07

New Member
Joined
Oct 10, 2017
Messages
11
Hello, dear VBA masters

Does anybody know how to transform text in cell into table using VBA
I have a list of our customers with their contact information. The emails and phone numbers are being stored in the cells. I need to extract them and create the table and use them / update and etc in future


This is the link for the file with the example

https://drive.google.com/open?id=10dsxoHesEgI3jv7kIWmZbThfawZGPGVo

Plz help

For example (what I have in cells):

Code:
Emails

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
 




 




xxxxxx@yahoo.com




First seen Sep 2009 and last seen Sep 2009 
 
 Run an email report  
 




 




xxxx11@yahoo.com




First seen Apr 2013 and last seen Aug 2018 
Type Personal 
 Run an email report  






 




xxxxxx2222@aol.com




First seen Nov 2008 and last seen Aug 2018 
Type Personal 
 Run an email report  






 




xxxxx44444@yahoo.com




 
Type Personal 
 Run an email report
needs to be similar to this:

User #1

<tbody>
</tbody>
xxxx11@yahoo.com

<tbody>
</tbody>
First seen Apr 2013 and last seen Aug 2018 ,Type Personal, Run an email report

<tbody>
</tbody>
User #1

<tbody>
</tbody>
xxxxxx2222@aol.com

<tbody>
</tbody>
First seen Nov 2008 and last seen Aug 2018, Type Personal, Run an email report

<tbody>
</tbody>

<tbody>
</tbody>


thank you for your help
 

Forum statistics

Threads
1,085,715
Messages
5,385,419
Members
401,945
Latest member
Paul82

Some videos you may like

This Week's Hot Topics

Top