+ Reply to Thread
Results 1 to 3 of 3

Move entire row from a table to another table in same sheet based on cell value

  1. 03-10-2020, 12:09 AM #1
    JayAr Viray
    JayAr Viray is offline
    Registered User
    Join Date
    03-09-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    2

    Move entire row from a table to another table in same sheet based on cell value

    Hi,

    I am struggling to find a VBA macro code that will automatically move a row from an excel table to another table (within same worksheet) once a cell value changes. Also, the data on the receiving table will be sorted according to date in descending order.

    Appreciate your help please. Thank you

    ccapture.JPG
    Reply With QuoteRegister To Reply
  2. 03-16-2020, 05:36 PM #2
    p24leclerc
    p24leclerc is offline
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Move entire row from a table to another table in same sheet based on cell value

    Here is some code that work like you want.
    YOu'll also find a worksheet with tables samples.
    Please Login or Register  to view this content.
    Hope this help
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.
    Reply With QuoteRegister To Reply
  3. 03-18-2020, 12:28 AM #3
    JayAr Viray
    JayAr Viray is offline
    Registered User
    Join Date
    03-09-2020
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    2

    Re: Move entire row from a table to another table in same sheet based on cell value

    Thank you so much Sir p24leclerc, this really helps!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move row from one table to another on the same sheet based on cell value
    By Ghostrider757 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-30-2022, 12:48 AM
  2. [SOLVED] Move Row from a Table in one sheet to a Table in another sheet depending on cell value
    By peterchclarke in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-31-2019, 08:44 AM
  3. Move an entire row to a new sheet based on the value of a cell.
    By jgroathouse in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2014, 08:16 PM
  4. Move an entire row to a new sheet based on the value of a cell.
    By jgroathouse in forum Excel General
    Replies: 0
    Last Post: 11-03-2014, 04:17 PM
  5. [SOLVED] Move entire row from one sheet to another based on cell value.
    By romanm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2013, 06:20 PM
  6. Move entire row to another sheet based on cell value
    By Hoodalolly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2013, 05:18 PM
  7. Move entire row to a new sheet based on cell value vba help
    By almasdour in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2013, 01:38 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1