+ Reply to Thread
Results 1 to 5 of 5

Cut/paste cells to a new sheet with certain criteria

  1. #1
    Registered User
    Join Date
    07-12-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    2

    Cut/paste cells to a new sheet with certain criteria

    I need to move cells A-M in a given row to another sheet based on a certain criteria. Right now I am using a code that moves the entire row (see below). How can I edit this in order to only take the values from A-M? I'd appreciate any insight, as I'm very new to this. Thanks!


    Please Login or Register  to view this content.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Cut/paste cells to a new sheet with certain criteria

    Try this
    Please Login or Register  to view this content.
    Air code of course, but you should be able to get the idea.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    07-12-2016
    Location
    United States
    MS-Off Ver
    2013
    Posts
    2

    Re: Cut/paste cells to a new sheet with certain criteria

    The whole row is still being moved--where should I put the line of code that you've provided? Thanks!

  4. #4
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: Cut/paste cells to a new sheet with certain criteria

    Please attached Sample file.

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Cut/paste cells to a new sheet with certain criteria

    Replace this
    Please Login or Register  to view this content.
    with this
    Please Login or Register  to view this content.

+ 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. Cut and Paste range of cells from one sheet to another when criteria is met
    By Buttercutie111 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-21-2016, 07:05 PM
  2. Replies: 1
    Last Post: 09-03-2013, 07:41 PM
  3. Search row with criteria in all sheet, copy rows and paste in new created sheet
    By dekueb in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-24-2013, 01:42 PM
  4. Cut the row from a sheet and paste it to another if certain criteria is met
    By mhaverk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2013, 05:00 AM
  5. Cut entire row and paste to new sheet if cells and date criteria match
    By themansion in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2013, 01:25 AM
  6. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  7. Copy Paste cells into a new sheet based on criteria macro
    By Clessie1919 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-19-2012, 02:43 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