Hi guys,
I'm pasting some info from the internet in an excel file.
I cannot paste it special transpose directly from the website (because if I choose paste special I have a choice between HTML, Unicode Text and Text)
Basicaly This
<table width="400" border="0" cellpadding="0" cellspacing="0"><tbody><tr><tr> <td width="380"> Member Name: Jewelers - IA
Address 1: 123 West Monroe
Address 2:
City: Pleasant
State: IA
Zip: 52641
Phone: 546544
Fax: 545465
Principal:
Additional Contact: </td></tr></tr></tbody></table>
must come out like this in one row.
I have to do this for a lot of time so I thought of making a macro. However, when I record the "paste special transpose" action. It always selects the same cells with my shortcut.
The best would be to find an option to paste special transpose directly from the website. But if that's not possible, at least that i can have a shortcut for paste special transpose.
Could someone help me with the code?
Thanks
I'm pasting some info from the internet in an excel file.
I cannot paste it special transpose directly from the website (because if I choose paste special I have a choice between HTML, Unicode Text and Text)
Basicaly This
<table width="400" border="0" cellpadding="0" cellspacing="0"><tbody><tr><tr> <td width="380"> Member Name: Jewelers - IA
Address 1: 123 West Monroe
Address 2:
City: Pleasant
State: IA
Zip: 52641
Phone: 546544
Fax: 545465
Principal:
Additional Contact: </td></tr></tr></tbody></table>
must come out like this in one row.
I have to do this for a lot of time so I thought of making a macro. However, when I record the "paste special transpose" action. It always selects the same cells with my shortcut.
The best would be to find an option to paste special transpose directly from the website. But if that's not possible, at least that i can have a shortcut for paste special transpose.
Could someone help me with the code?
Thanks