Results 1 to 3 of 3

Mark or Delete Rows based on Matching Multiple Criteria in another worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Mark or Delete Rows based on Matching Multiple Criteria in another worksheet

    Main Worksheet contains addresses grouped by List#. Column Headers include (List#; Record#; FirstName; LastName; StreetAddress; City; State; ZipCode; Phone)
    The Criteria worksheet contains (List#; Keep)

    On the Main worksheet I have added a sequential record number for each List#
    The Criteria worksheet shows the number of records (rows) to keep for each List#

    The worksheet can contain anywhere from 1 to 100+ separate List#s.
    I would like to find the best way to create a macro to look at the rows on the criteria worksheet and move rows on the Main worksheet, that match the criteria, to a new worksheet labeled "Match".
    If the row matches the List# and is <= to the qty to keep it would be moved to a new worksheet labeled "Match"
    If the row matches the List# and is > than the qty to keep it would be retained on the Main worksheet
    Then proceed to the next row until all rows have been processed.


    I have attached sample data. All information on the sample data is fictitious.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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