Closed Thread
Results 1 to 4 of 4

Way to pull in new data from web and leave the old?

  1. #1
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Way to pull in new data from web and leave the old?

    I am trying to find a way to have the attached spreadsheet pull in new market data and leave the old. For example, the CBOT provides current market pricing for corn starting in May'13 and ending Dec'15. The months change as time advances. My spreadsheet pulls in the current market data (see Corn CBOT tab) and then summarizes it on the final tab, Commodity Prices 12 mo. period. When I originally put the spreadsheet together I only wanted 12 months of pricing (essentially the next most current month and forward). Now, I'd like to be able to use the past months and the future months.

    I might have to hand enter some historical prices to get going but starting now and forward, is here a way I can have the program not overwrite or zero out the previous months pricing on the Summary tab and show the past six onths and all forward months on the Commodity Prices 12 mo period tab?

    Commodity Prices swine tpk april 2013.xlsx

    Thanks!

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Way to pull in new data from web and leave the old?

    Is this solved?

    If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-06-2012
    Location
    MN
    MS-Off Ver
    Excel 2013
    Posts
    62

    Re: Way to pull in new data from web and leave the old?

    Sorry that I was not clear - I have not solved this issue and am looking for help. The nature of the problem shifted a bit so I started another thread because I could not figure out how to delete this one.

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Way to pull in new data from web and leave the old?

    Thread closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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