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):
needs to be similar to this:
<tbody>
</tbody>
thank you for your help
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 reportneeds to be similar to this:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
thank you for your help
