Display fetched data in single sheet

hi

I found a code which fetch data from the web and displays the data in excel. However the code displays the data in different sheets which is based on 7 pages of the website. Can you please help me modify the code in such a way that it would display the fetched data in a single sheet only? Thanks in advance.

Please Login or Register  to view this content.

Try next code
NOT TESTED

Please Login or Register  to view this content.

Hi PCI,

Thanks for your reply. I tried your code, and it copied the details in one sheet. However, the data pasted displays like stairs in appearance How can this possibly be displayed in one sheet such that the succeeding pages apprears at the bottom of every page? Instead of creating new columns for another page?

Thanks

As for containment use next code
All information merge in the first sheet

Please Login or Register  to view this content.

hi PCI,

thanks for trying to help. Maybe I was not clear enough with my problem. I'm sorry for all the troubles...Anyway I have attached a sample workbook of the output I need. Thanks in advance...

Containment step 2

Please Login or Register  to view this content.