Results 1 to 5 of 5

Cut and Copy Row into Another Sheet based on Two Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2015
    Location
    USA
    MS-Off Ver
    Office 2013
    Posts
    27

    Cut and Copy Row into Another Sheet based on Two Criteria

    Hello there.

    I know next-to-nothing about programming VBA, and need some help with a problem. I've searched the forums and found several items similar to my issue, but I cannot seem to configure the code provided in those threads to work for my spreadsheet, hoping somebody might be able to assist.

    I have a job summary page, and each row contains details about various jobs. If two criteria are met in each row, I'd like to be able to use a Macro to remove those rows from the main summary page and place them in another tab specifically for items containing these criteria.

    Via the worksheet attached, the criteria would be Column B (Status) = Complete & Column E (Days Cleared) >=150. The moved rows would compound on the sheet 'Complete' so that using it in several instances, the moved rows would just stack and I could use Data>Sort to keep everything in-line.

    Any help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by SabbathXXL; 02-19-2015 at 04:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  2. copy one row from one sheet to another sheet in excel based on criteria
    By pawan.dbm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 01:46 PM
  3. [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
  4. Replies: 4
    Last Post: 07-24-2012, 07:09 AM
  5. Need Macro to search from mater sheet and copy in another sheet based on Criteria
    By humacdeep in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-29-2012, 01:03 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1