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.
Bookmarks