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.
Bookmarks