+ Reply to Thread
Results 1 to 1 of 1

VBA Function to Update Rows in Linked Table

  1. #1
    Registered User
    Join Date
    03-23-2016
    Location
    Toronto
    MS-Off Ver
    2007
    Posts
    5

    VBA Function to Update Rows in Linked Table

    I've got my data organized in the following Excel table.

    http://imgur.com/a/JgiKz

    This table is automatically populated from an external website every day. So each day, an unpredictable number of new rows of data will appear (between one and five).

    This data is fed into a second table located in another sheet, where it performs some operations on the data using a custom VBA function.

    http://imgur.com/a/jfwYd

    So the first cell in this table is =Sheet!A3 and the next one is =debt_pershare(Sheet1!B3, Sheet1!C3, Sheet1D3) etc.

    This data is then taken into a third PowerPivot table where's it's unpivoted and graphed.

    If there are any #VALUE errors or any blank rows in the second table, then the PowerPivot part won't work. So that means whenever the first table updates, I have to manually drag down the rows for the second table to update the second table with the new data, so that it's got the same number of rows as the first table and incorporates all the new data.

    Is there a way I could write a VBA function to skip this second step, so that it automatically updates the second table when new information is added to the first? If the second table has a greater number of rows than the first, the whole thing breaks down, so it needs to update just enough to match the first table.
    Last edited by varunc777999; 10-17-2016 at 10:59 AM.

+ 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. Insert rows in linked table that are added to secondary table
    By Ida LaValley in forum Excel General
    Replies: 4
    Last Post: 11-16-2020, 12:00 PM
  2. Replies: 1
    Last Post: 02-15-2016, 05:47 PM
  3. [SOLVED] Linked Table does not hold position on page after update
    By phook01 in forum Word Formatting & General
    Replies: 6
    Last Post: 06-17-2015, 10:18 AM
  4. [SOLVED] Help! Problem using Indirect function to update master workbook from linked files
    By treetrunk in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 06-13-2014, 05:47 AM
  5. Replies: 3
    Last Post: 07-31-2012, 05:19 PM
  6. update new rows from linked data
    By JakeAy in forum Excel General
    Replies: 1
    Last Post: 12-18-2009, 04:05 AM
  7. insert rows and update linked cells
    By Laura in forum Excel General
    Replies: 2
    Last Post: 08-26-2005, 03:05 PM

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