Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create HTML code for a hyperlink from cell contents | Excel Worksheet Functions | |||
How could I display an excel cell contents in a page header ? | Excel Worksheet Functions | |||
Copy contents to another page | Excel Worksheet Functions | |||
copy cell contents to different page | Excel Discussion (Misc queries) | |||
how do I keep clipboard contents active in excel? | Excel Discussion (Misc queries) |