Results 1 to 3 of 3

Updating values in a specific table column, and specified row

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2012
    Location
    Bay Area, California
    MS-Off Ver
    Excel 2016
    Posts
    28

    Updating values in a specific table column, and specified row

    I have a table where left-most column holds a unique ID for each row.
    To the right of the uniqueID column, I have several columns with attributes for each ID:

    |UNIQUEID|FAMILY|VOLUME|TARGET_COMPLETION_DATE|ACTUAL_COMPLETION_DATE|
    |ProdA |Widget|2,000 | 3/4/2017 | 2/17/2017 |
    |ProdB |Carrots| 300 | 5/5/2017 | -blank- |
    |ProdC |Towels| 770 | 12/22/2017 | -blank- |



    I use this master table to track completion %, and summarize progress according to attributes (using SUMIFS(...) and such) in a separate reporting sheet.

    Others send me updates listing the subset of ID's which have changed status in one of the columns. This update sheet will list the new value to be loaded for the UniqueID and Column they wish to update.

    For example, I'd get something like this:

    |UNIQUEID|ACTUAL_COMPLETION_DATE|
    |ProdB | 9/21/2017|


    Is there an easy way to reliably load these new cell values according to only the rows of the stated UniqueIDs and the referenced column name?
    All the columns I accept value updates are loaded with values (not formulas).

    Thank You!
    Last edited by Dominicus; 09-21-2017 at 11:38 PM. Reason: claify

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA updating SPECIFIC Pivot table with PivotTableUpdate
    By Hawkansson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2016, 10:58 AM
  2. Removing certain values from a Pivot Table and updating the totals
    By lalahaedong_excel in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-26-2015, 02:18 PM
  3. Macro in excel to copy specific values from a table with a specific criteria
    By Adam Brave in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2015, 05:40 AM
  4. Sum Values in a Table Matching Specific Row and Column Values
    By dubasteins in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-15-2014, 09:06 AM
  5. Hiding specific column and updating information on another sheet.
    By ajitexcelfourm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2014, 03:57 AM
  6. updating table values do i need a VBA macro?
    By excelsnoopy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-30-2012, 12:40 PM
  7. updating table values from drop down list
    By jw01 in forum Excel General
    Replies: 11
    Last Post: 11-30-2010, 12:35 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