Macro Paste - Copy - Paste Special Transpose

carlo

New Member
Joined
Jan 14, 2010
Messages
4
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
You could split it into two columns using Data > Text to Columns, specify Delimited and : as the delimiter.
 
Upvote 0
This is an extra step for me. I want to keep the steps to a minimum. Right now I'm allready

1.copy from website
2.paste to excel

3.recopy from excel
4.paste special transpose

If I could make a shortcut at least for the paste special transpose i will be happy
 
Upvote 0
A macro for "paste special transpose" ?

This is a simple one:


Sub PasteVal()
Selection.PasteSpecial Paste:=xlValues
End Sub
</pre>
How do I add the transpose?
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top