Results 1 to 24 of 24

Move row to different table depending on cell value

Threaded View

  1. #1
    Forum Contributor Marco-Kun's Avatar
    Join Date
    04-14-2009
    Location
    Holland
    MS-Off Ver
    Dutch:2007
    Posts
    298

    Move row to different table depending on cell value

    Hello everyone,

    Added workbook has an example added.

    There are two tables on this workbook: Rewatching and Rewatched.
    I want to move entire rows, plus the comments with pictures added, from Rewatching to Rewatched if the cell in column G in the table Rewatching = "Completed".
    The value in column G is updated with a formula.

    In the added workbook row 9 should be moved to Rewatched, as the value in G9 = "Completed".

    The code should also check whether or not the title in column A is already present. If it is, it only has to update the value in the corresponding row in column L + 1.
    For example; Row 11. Death Note, G11 is "Completed" but Death Note is already present in the Rewatched table. So L3 should be updated +1.

    In both cases, delete the target row in the Rewatching table.

    Kind regards,

    Marco
    Attached Files Attached Files
    Last edited by Marco-Kun; 12-18-2011 at 06:03 PM.

Thread Information

Users Browsing this Thread

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

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