Results 1 to 1 of 1

Looking for help writing a VBA code to move a row from one table to another once completed

Threaded View

mtaggart5 Looking for help writing a... 03-22-2016, 09:53 PM
  1. 03-22-2016, 09:53 PM #1
    mtaggart5 is offline
    Registered User
    Join Date
    03-22-2016
    Location
    Charlotte, NC
    MS-Off Ver
    2007
    Posts
    1

    Looking for help writing a VBA code to move a row from one table to another once completed

    I am looking for help with a VBA code to move a row from the top table to the bottom table once it is marked as "Closed" in the status column. I would like the original row to be deleted once it has moved. I have tried a few codes from other threads but none seem to be working - there seems to be an easy way to do it but I keep running into trouble.

    I've also included a rough copy of the template I have been working from.

    Thanks for any and all help!
    Attached Files Attached Files
    Last edited by mtaggart5; 03-22-2016 at 11:01 PM.
    Reply With QuoteRegister To Reply
« 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. Code to move completed rows in a table to another worksheet- excel 2010
    By big_cg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-13-2014, 06:38 AM
  2. VBA to move a row of completed data to another sheet.
    By applegerls in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-21-2014, 11:02 AM
  3. [SOLVED] Code to move data from an entry table to a historical table by date.
    By rlh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2014, 11:04 AM
  4. [SOLVED] Move completed item to new sheet
    By johnplyer in forum Excel Programming / VBA / Macros
    Replies: 46
    Last Post: 12-10-2013, 08:03 PM
  5. Move Completed Items to a new worksheet.
    By Linzela42300 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2013, 01:48 PM
  6. [SOLVED] Move a row to another sheet after status says completed
    By rjclampitt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-10-2012, 06:32 PM
  7. Writing Code for creating pivot table
    By kw42chan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-03-2011, 11:40 AM

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