Want macro to copy, paste special and text from multiple web page to excel sheet in d

winmaxservices1

New member
Joined
Mar 12, 2014
Messages
2
Reaction score
0
Points
0
Hi,
I Have opened a webpage, multiple pages by clicking add tab. Now I wants to copy paste web page to excel sheet in different column.

E.g 15 to 20 pages are opened in google chrome. Now I want to copy and paste (select all webpage(ctrl+a), copy(Ctrl+C) and in already opened excel sheet in column A paste special and then text, next xopy data in second tab, paste special text in column B. till all the data copied from already opened webtab. The number opened web tab is not specific, it may be 1 or 10 or may be 15. In short After opening all the webtab when the macro runs it should copy all date from webtab to excel sheet. Please help
 
Top