Results 1 to 4 of 4

Create update table with changes from subtable

Threaded View

  1. #1
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,296

    Create update table with changes from subtable

    I have two tables, with the same key values, as in the attached. The first is the original table (in the attached, tblOriginal), and the second table (tblChange) only contains some of the fields from the original. The end result that I want is to keep all the values from the original table except those values that appear in the second table, shown in tblResult.

    It doesn't matter if it is a formula or power query - I'm just at a loss for the best way.

    Thanks,
    Bernie
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add a subtable in mailmerge
    By JohnCamus in forum Word Formatting & General
    Replies: 2
    Last Post: 08-29-2017, 05:06 AM
  2. Replies: 0
    Last Post: 04-06-2017, 02:56 AM
  3. VBA to create/update pivot table from other workbooks
    By KOstey80 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2017, 11:17 AM
  4. Create New row in a table and copy/update formulas VBA
    By whitenoise22 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-25-2012, 03:07 AM
  5. retrieve rows from table on sheet1 to insert in subtable on sheet2
    By ycubed in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2010, 12:33 AM
  6. create league table :: enter result :: update table
    By Eng.Soly in forum Excel General
    Replies: 2
    Last Post: 12-27-2008, 06:31 AM
  7. [SOLVED] Create Table; Update Table: MS Query
    By astrodon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2008, 06:39 AM

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