+ Reply to Thread
Results 1 to 2 of 2

Column with various dates update on that date with refreshed data from website query

  1. #1
    Registered User
    Join Date
    01-04-2015
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    2

    Column with various dates update on that date with refreshed data from website query

    Hello all,

    I'm fairly new to excel and need some assistance. I'm working on something that will analyze prices of players in Fifa Ultimate Team over time (for fun). Where I am stuck is how I get the avg price to update on the date that is specified by the date column. So, I have a query pulling price data off of a website once a day for various players, then I have a single cell that takes those prices and averages them. I want to have that average then fill a cell for price in a table that has Player Name, Date, and then price. How would I do that and not have the previous days value update as well?

    I would have searched for other threads with people having this same problem, but am uncertain of what I would search.

    Any help would be greatly appreciated. I'll go ahead and upload the sheet I'm working from to give you a better idea.

    Thanks.What I need help with.xlsxWhat I need help with.xlsx

  2. #2
    Registered User
    Join Date
    01-04-2015
    Location
    Minneapolis, Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Column with various dates update on that date with refreshed data from website query

    I am also open to other ways to accomplish the same goal.

+ 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. urgent : update my price column from a website
    By sarv92 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-07-2014, 03:27 AM
  2. Web query refreshed data should get saved
    By purusharth in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-15-2013, 01:44 AM
  3. Replies: 0
    Last Post: 08-03-2011, 08:40 AM
  4. [SOLVED] Downloading Refreshed Web Query Data into Adjacent Column
    By SteveC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2006, 12:35 PM
  5. Capture Date when Query Refreshed
    By FrankTimJr in forum Excel General
    Replies: 0
    Last Post: 01-28-2005, 11:06 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