Data Input

[Nyamu]

Hi ya'all. I want to copy an unstructured piece of work from a website to my excel sheet. To be specific i'm inputting Infectious diseases and there symptoms and diagnosis. There's a database with all that but you have to check the symptoms per disease. I, however want to paste all the symptoms and diseases at a go. Is there a way to do this?
This is the file.

 

[Chihiro]

Please be more detailed in your requirement. Looking at your file. I have no idea what you are trying to do here.

 

[Marc L]

Hi !​

Is there a way to do this?

Maybe yes, maybe no, who knows ?! As you can start with an easy copy / paste operation …​

​

As here is the Excel formula forum so if you have an enough recent Excel version​

see the Excel help of the WEBSERVICE & FILTERXML worksheet functions …​

​