Pull very specific data from web queries

[disk1of3]

I'm fairly new to figuring out the inter-workings of Excel, but I know that it can do what I need.

I need to pull specific data from WebFLIS and have the information be put into specific cells.

For instance I created a web query using this address https://www.dlis.dla.mil/webflis/pub...rch.aspx?NIIN=parameter&v=1111111&r=FL

I will have my collegues search by inputing the nsn as the parameter.

As an example of what a completed address would look like, here you go https://www.dlis.dla.mil/webflis/pub...v=1111111&r=FL

All of the things that I need to go into specific cells are: NSN, Item Name, CIIC, Phrase-Code-Data, and DOT HAZARD CLASS/DIVISION

Thanks for reading

[kelly7898]

Thank you so much for your post.

[levindi]

Hi,

I am looking for the same thing in the same URL!

Did you find an answer / any other solutions ?
Please write me or give an E-mail.

Thanks,