+ Reply to Thread
Results 1 to 5 of 5

Macro to move rows once complete

  1. #1
    Registered User
    Join Date
    01-25-2023
    Location
    england
    MS-Off Ver
    2019
    Posts
    3

    Lightbulb Macro to move rows once complete

    Hello,

    I am creating an activity tracker that once a task is complete moves to a separate list
    I've tried different codes i have found on here but none of them seem to work,

    Can someone help me please?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Macro to move rows once complete

    Place this in the To-Do List worksheet module



    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-25-2023
    Location
    england
    MS-Off Ver
    2019
    Posts
    3

    Re: Macro to move rows once complete

    Hello,

    Thank you for the code,

    It doesn't appear to be moving the completed rows and just deleting the row out of the workbook, what would i add / change to make that happen?

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Macro to move rows once complete

    Look bellow row 33, I guess you are pasting it to a table so it is pasting to the bottom of the table.

  5. #5
    Registered User
    Join Date
    01-25-2023
    Location
    england
    MS-Off Ver
    2019
    Posts
    3

    Re: Macro to move rows once complete

    Thank you that worked

+ 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. [SOLVED] Move Complete Rows to bottom of Worksheet
    By Likayuu19 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-23-2019, 10:55 AM
  2. [SOLVED] Macro to Move Rows to New Worksheets Based on Criteria & Then HIDE & Move Back
    By abro0821 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2014, 04:00 PM
  3. [SOLVED] Macros To Move Multiple Rows To Another Sheet And Macro To Move Single Rows To DAX Table
    By jcaynes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 05:08 PM
  4. [SOLVED] Move all rows where cell = "complete" to the bottom of the list
    By floribunda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-15-2013, 03:25 PM
  5. [SOLVED] Macro to move complete row from one worksheet to another
    By Kimston in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-10-2012, 11:01 AM
  6. Help, please: Copy rows to new sheets, then move row to new sheet when complete
    By dmrogers001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2012, 01:01 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