Hi,

I have a webpage from which i am selecting & copying vertical data. Now
I open Excel & select Cell A5 & then right-click & select PasteSpecial,
then in PasteSpecial window, select Values & Transpose, to transpose
data horizontally.

I want to automate the whole process so that once i select & copy
webpage data, it should already be available in windows Clipboard, so
that once i open Excel, i just need to click on a button & it will
collect data & paste it horizontally from cell A5.

Also, once row cells are filled, the next time i enter another webpage
data, it should paste it horizontally to cell A6 below.

Please help!

Sifar