+ Reply to Thread
Results 1 to 8 of 8

Need help auto refreshing filterxml... Anyone???

  1. #1
    Registered User
    Join Date
    06-07-2014
    Posts
    4

    Need help auto refreshing filterxml... Anyone???

    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

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help auto refreshing filterxml... Anyone???

    Can't you just make that file part a cell reference, like you have done for typeid?

    =FILTERXML(WEBSERVICE("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&A2),"/evec_api/marketstat/type/" & G2 & "")

    Where G2 contains one of the following,

    buy/max
    sell/min
    buy/volume
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    06-07-2014
    Posts
    4

    Re: Need help auto refreshing filterxml... Anyone???

    cell g2/h2...etc contains the Id number of the items im pulling data for such as

    trit=1230 so in g2 i would have 1230

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help auto refreshing filterxml... Anyone???

    If G2 already contains stuff simply change the cell to one that doesn't.

  5. #5
    Registered User
    Join Date
    06-07-2014
    Posts
    4

    Re: Need help auto refreshing filterxml... Anyone???

    Do you have a e-mail where i can send you the sheet and you can walk me throu hwo to do it?

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help auto refreshing filterxml... Anyone???

    No. Use the forum.

    See attached, the choice of information type is A5
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    06-07-2014
    Posts
    4

    Re: Need help auto refreshing filterxml... Anyone???

    awsome now how would i do that to use a2-a57 with all different id's?

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Need help auto refreshing filterxml... Anyone???

    Do what exactly.
    I shown you how you can replace parameters within the formula using cell references. All you need to do is adapt for you workbook and cell layout

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pivot tables not auto refreshing
    By doubl3d80 in forum Excel General
    Replies: 0
    Last Post: 06-14-2012, 09:26 AM
  2. Refreshing auto-filters -Help!
    By farmertml in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-13-2009, 11:25 AM
  3. MS Query Not Auto Refreshing
    By JuSlaughter in forum Excel General
    Replies: 2
    Last Post: 03-21-2007, 01:59 PM
  4. [SOLVED] Tool for auto loading/refreshing/updating/etc...
    By Richard Edwards in forum Excel General
    Replies: 1
    Last Post: 01-26-2006, 09:25 AM
  5. [SOLVED] Tool for auto loading/refreshing/updating/etc...
    By Richard Edwards in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2006, 09:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1