Results 1 to 4 of 4

Automatically expand table 1 after adding data to table 2

Threaded View

  1. #1
    Registered User
    Join Date
    10-30-2020
    Location
    Den Bosch, Netherlands
    MS-Off Ver
    365
    Posts
    15

    Automatically expand table 1 after adding data to table 2

    Hi all,

    I need some help, preferably without using a Macro. But if it is neccesary than for it to work a Macro would be great as well.

    My problem is that I am requiring exports from 2 different places with different names for columns.
    Thats why I decided to make 1 table where only the neccesary data from both places is shown.

    I attached a file with 3 worksheets.
    *Table 1: Main table with only neccesary data extracted from both other worksheets.
    *Table 2: Datatable 1
    *Table 3: Datatable 2

    What I would like is that only if data is added into "Table 2" than automatically this expands Table 1 with the neccesary data.

    Is this possible and if so how?

    Many thanks in advance!
    Attached Files Attached Files
    Last edited by larsvane; 08-05-2024 at 04:59 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically expand formula when adding coumns
    By eol666 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-26-2023, 05:39 AM
  2. Replies: 2
    Last Post: 02-20-2022, 08:44 PM
  3. Automatically extend line graph when adding more data into a table.
    By mavaspa in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-01-2016, 02:25 AM
  4. Make Table Automatically Expand Rows NOT Columns
    By Yanezez in forum Excel General
    Replies: 1
    Last Post: 02-23-2016, 05:08 AM
  5. Expand a table by adding rows ( table feature 2007 and later)
    By Pepe Le Mokko in forum Excel General
    Replies: 3
    Last Post: 08-13-2013, 05:12 AM
  6. automatically adding up data from large table
    By Qwerty in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-19-2010, 11:36 AM
  7. Stop automatically adding data to pivot table
    By wburbage in forum Excel General
    Replies: 2
    Last Post: 06-15-2010, 03:31 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