trying to create a button/macro to switch a column of cells from
=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&a2),"/evec_api/marketstat/type/buy/max")
to
=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&a2),"/evec_api/marketstat/type/sell/min")
without having to manually put it in, also is there a way to auto refresh
=FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&a2),"/evec_api/marketstat/type/buy/volume")
without having to take it out and put it back in?????
Thanks
Bookmarks