+ Reply to Thread
Results 1 to 1 of 1

Dynamically change table size that contains formula

  1. #1
    Forum Contributor
    Join Date
    06-08-2021
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    101

    Dynamically change table size that contains formula

    Hi,

    In the attached macro-enabled excel workbook, I have four sheets "Source", "New", "Past" and, "Report". Source file gets data automatically from a .csv file that is generated from ERP and "New" sheet references to certain column cells in source to refine the data. "Past" holds the immediate previous data (i have an action button that runs a basic macro to copy and paste data from "New" to "Past" before the new data comes into "Source") if the "Source" data changes. "Report" calculates the difference in data between "New" and "Past". I want to have the table in "Report" to dynamically change its size while holding the formula that it holds based on the table sizes in "New" and "Past". Meaning, if number of Rows changes in "New" and "Past", the number of rows in "Report" must change to record all the differences in data. The number or columns in "New" and "Past" never changes. If a vba code is required, I am okay to use macros as well, as I already have one in the file. I would really appreciate if anyone can help me on this.

    thanks in advance

    VR
    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] Can I change Font size without changing cell size? Or confine row height change to one col
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2018, 11:18 AM
  2. SOLVED-Dynamically change size/range of x axis of chart
    By helpme858 in forum Excel General
    Replies: 2
    Last Post: 08-07-2017, 12:20 PM
  3. Replies: 1
    Last Post: 06-20-2017, 02:08 AM
  4. Change source of pivot table dynamically based on sheet name
    By jeroenft in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2016, 11:23 AM
  5. Dynamically Change Marker Size and Background Colour for XY Scatter
    By MJU007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-05-2016, 05:19 PM
  6. [SOLVED] Dynamically Changing Position of Pivot Based on Size of Another Pivot Table
    By ggilzow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2013, 02:42 PM
  7. Change size of Excel Data Table, dynamically
    By joshjpang in forum Excel General
    Replies: 10
    Last Post: 02-08-2013, 06:26 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