Hi to all
this is my first question about this and till few moments ago i didn't even know something like this exist is excel
I'm trying to do next
In cell A1 is drop list
In cell A2 is drop list
In cells B3:B6 are specifications for product from list A2
I have formula in A7
=HYPERLINK("http://api.erepublik.com/v2/feeds/market/"&A1&"/"&A2&"/"&B3&"/"&B4&"/"&B5&"/"&B6)
what i want next is import data from that link to excel
ex. http://api.erepublik.com/v2/feeds/market/1/1/10/10
that data i wish to import
Maybe after user select and type desire description, he must press some import button and then data is imported
Don't know how better to explain, as I said this is my first time working with xml
thanks
this is my first question about this and till few moments ago i didn't even know something like this exist is excel
I'm trying to do next
In cell A1 is drop list
In cell A2 is drop list
In cells B3:B6 are specifications for product from list A2
I have formula in A7
=HYPERLINK("http://api.erepublik.com/v2/feeds/market/"&A1&"/"&A2&"/"&B3&"/"&B4&"/"&B5&"/"&B6)
what i want next is import data from that link to excel
ex. http://api.erepublik.com/v2/feeds/market/1/1/10/10
that data i wish to import
Maybe after user select and type desire description, he must press some import button and then data is imported
Don't know how better to explain, as I said this is my first time working with xml
thanks