+ Reply to Thread
Results 1 to 1 of 1

Live data import to populate a growing table

  1. #1
    Registered User
    Join Date
    09-27-2017
    Location
    Lexington, Kentucky
    MS-Off Ver
    Excel 2016
    Posts
    1

    Live data import to populate a growing table

    I am trying to write a relatively simple spreadsheet to run calculations based on a two column table of data. The problem is that my requirements for importing the data are very specific. Is there a command for importing a piece of data and appending it to an existing table? To be more specific, the data I am concerned with updates daily (only on weekdays), and I am concerned with what it is doing every day after the date I begin sampling. I want a macro that will retrieve the daily data point from the web and add it to the end of my table so that my calculations may take effect. Please find a desensitized version of my workbook attached for clarification. The cells highlighted in yellow are where the table should populate, the grey cell is for user input, and the remaining cell conducts the calculations.

    TL,DR:
    How do I import a single data point daily and add it to the end of a growing table with a macro?

    Thanks in advance,
    LF
    Attached Files Attached Files

+ 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. [SOLVED] Populate a combobox with unique names from a growing list
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2016, 05:16 AM
  2. Live import of web data that is NOT in an HTML table
    By ChefHoovisan in forum Excel General
    Replies: 0
    Last Post: 08-18-2016, 09:53 AM
  3. How to look up a value in a ever growing table
    By michellepace in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2016, 03:49 AM
  4. Live Pivot table and trying to archive data
    By Frasier433 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 11:21 AM
  5. Reading last row of growing table
    By agentred in forum Excel General
    Replies: 3
    Last Post: 07-09-2010, 01:22 PM
  6. [SOLVED] File Size Keeps Growing On Import
    By les4825 in forum Excel General
    Replies: 0
    Last Post: 03-01-2006, 05:20 AM
  7. [SOLVED] Show value in Data Table but not on live chart
    By Gonepostal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2006, 08:25 AM

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