+ Reply to Thread
Results 1 to 3 of 3

Extracting Data from one table to move to another when values match

  1. #1
    Registered User
    Join Date
    08-25-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Extracting Data from one table to move to another when values match

    I am trying to move data from one table to another. Is this realistic: Once Level and Status equal Complete, I want to move the Row Data from Task Data table to the True Data table. I inherited this project. These are large tables and it is very time consuming to manually update this data. I tried creating an additional table to include Match & Index, but I'm missing something. The outcome of True Data is to receive only columns: State and Team. The third column is a consistent statement"current with proposal" . Can you let me know if this is possible?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-11-2012
    Location
    bengalur
    MS-Off Ver
    Excel 2003, 2007
    Posts
    152

    Re: Extracting Data from one table to move to another when values match

    It would be easy in the VBA coding.....

    _______________________________________________________________________________________________________________________________________
    Please click * to say thank you

    “I have not failed. I've just found 10,000 ways that won't work.”
    ― Thomas A. Edison

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Extracting Data from one table to move to another when values match

    Pl see attached file.
    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. Replies: 1
    Last Post: 08-31-2012, 10:35 PM
  2. Replies: 1
    Last Post: 07-27-2011, 04:19 AM
  3. Extracting values from a Xcel Table
    By k3nparikh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-01-2009, 10:14 AM
  4. Extracting values from a table
    By Rob Cherry in forum Excel General
    Replies: 2
    Last Post: 04-02-2006, 06:25 PM
  5. [SOLVED] Extracting values from a table
    By Rob Cherry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2006, 05:30 PM

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