+ Reply to Thread
Results 1 to 2 of 2

Move row from one table to another based on cell value

  1. #1
    Registered User
    Join Date
    06-08-2020
    Location
    Norway
    MS-Off Ver
    365
    Posts
    2

    Move row from one table to another based on cell value

    Okey i have a question,

    i would like to move a row from one table to another based on cell value if a cell value goes from 1 to 0.

    Both tables are in the same activesheet.

    Have been trying to write a code but not succeeded.. appreciate any tips!

    Would be nice to make it go in reverse as well, if i type "0" in the secound table it will move the row back to the first table.
    Attached Files Attached Files
    Last edited by eikenesn; 06-29-2020 at 08:39 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    371

    Re: Move row from one table to another based on cell value

    Hi eikenesn,
    For members to be able to help, it is always better to attach a sample workbook (see yellow banner at the top). this makes it much clearer how your data is structured. Also show how the result should look like etc.
    If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.

+ 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: 04-24-2020, 10:30 AM
  2. Move entire row from a table to another table in same sheet based on cell value
    By JayAr Viray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2020, 12:28 AM
  3. Move row from one table to another on the same sheet based on cell value
    By Ghostrider757 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-12-2017, 11:13 AM
  4. How do I move totals into a table based on the day?
    By Virtualistix in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2016, 06:56 AM
  5. Move Row to another table based on cell value
    By janarthenan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-10-2016, 06:41 PM
  6. Move or delete cell information based on reference table
    By JW90 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2016, 02:06 AM
  7. Move rows in a table based upon a certain criteria.
    By Sm1tty in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-05-2014, 04:48 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