+ Reply to Thread
Results 1 to 6 of 6

Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop down

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    Liverpool,England
    MS-Off Ver
    2010
    Posts
    3

    Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop down

    Hello Excellers,

    I've been looking/adapting code for quite a while for my problem and I can't quite find a code that will help me so I hope you guys and gals can.
    I am looking to move entire rows of data based on criteria in column K (either 'Closed' OR 'Cancelled') from one sheet (ChangeRegister) to another sheet (Archive), then to delete the empty rows on the source spreadsheet. This is for use by other people including me so I don't want to put the code straight in the VBA editor, rather I will attached it a button to be pressed once a week.

    Spreadsheet attached.

    Any help would be really fantastic.

    K
    Attached Files Attached Files
    Last edited by kmort; 12-23-2015 at 08:03 AM.

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

    Re: Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop d

    Will the button be in the workbook? When you click the button, where do you believe the code for that button is located?

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

    Re: Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop d

    Can you work with this?

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    11-11-2015
    Location
    Liverpool,England
    MS-Off Ver
    2010
    Posts
    3

    Re: Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop d

    Hi Dave, the button will be in the workbook and the code will be in a module?

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

    Re: Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop d

    Quote Originally Posted by kmort View Post
    Hi Dave, the button will be in the workbook and the code will be in a module?
    A module is in the VBA editor

  6. #6
    Registered User
    Join Date
    11-11-2015
    Location
    Liverpool,England
    MS-Off Ver
    2010
    Posts
    3

    Re: Macro to cut/paste entire rows from one tab to Archive tab based on criteria in drop d

    Thanks so much Dave, I just changed the paste values to keep source formatting (I have some dates in the rows) and it works perfectly.
    What I meant to say is I didn't want the code to run automatically as soon as a status is change to complete.

    Thanks again.

+ 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] Copy/Paste rows based on certain criteria (drop down or colors)
    By jholiday78 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2014, 08:15 PM
  2. Cut and Paste entire row based on criteria - Need help
    By NateS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 04:52 PM
  3. [SOLVED] Copy entire row based on 2 criteria and paste on the next blank row on a specific sheet
    By ALNER in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-25-2014, 11:23 PM
  4. Replies: 3
    Last Post: 08-15-2013, 01:22 PM
  5. [SOLVED] Cut and Paste entire row to new worksheet based on criteria in 1 cell
    By KS1986 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2012, 05:56 AM
  6. [SOLVED] Macro the hides entire rows based on a drop down list
    By MGK086 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 11:32 AM
  7. [SOLVED] Macro to copy and paste rows to a new sheet based on criteria
    By Belo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-31-2010, 02:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1