+ Reply to Thread
Results 1 to 2 of 2

need help moving data around in a table

  1. #1
    Registered User
    Join Date
    02-07-2018
    Location
    indiana
    MS-Off Ver
    office 2016
    Posts
    1

    Question need help moving data around in a table

    I have 2 tables. table 1, table 2. Table 1 is top table and primary table. Table 2 is bottom table and secondary table. Both tables have same columns. A-R. These are filtered tables with the drop down arrows in boxes in header row. This is what I would like to do. In my top table I want to put the letter "T" in any cell in the R column. when i do this I want the entire row to be copied in the lower table. In the bottom table when I remove the "T" in R column it moves the entire row back up to the top table. Top table needs to have about 30 rows, while the bottom table needs to have about 15 rows. I will probably never use the last 5 or so rows in each table but want them there just in case. Can anyone help with this.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: need help moving data around in a table

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Moving data from one table to another
    By cheesemarathon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2016, 07:19 AM
  2. Moving a data Table to new sheet
    By pauldaddyadams in forum Excel General
    Replies: 1
    Last Post: 05-17-2012, 06:46 AM
  3. Excel 2007 : Moving data from one table to another
    By hossains in forum Excel General
    Replies: 0
    Last Post: 04-18-2012, 09:57 AM
  4. Moving data from 1 table to another on different worksheet?
    By rocknrollmommy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2011, 06:29 AM
  5. Moving data from a pivot table to another table based on conditions
    By MarinaDBrown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2009, 12:11 PM
  6. moving table data between worksheets
    By Xaos in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 04-23-2008, 11:56 PM
  7. Moving Table Data to other worksheets.
    By Chuck in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2006, 04:50 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