Be kind this is my first post
I have attached an example sheet.
- Column G represents the ShipDate* for an order
- Column I represents the OrderNumber
- The Sheet is Sorted by ShipDate
Macro Objective: IF ShipDate Range is a duplicate AND OrderNumber is a duplicate within the ShipDate Range THEN
....CUT THE ENTIRE SET OF ROWS TO A NEW SHEET
*want to evaluate a ShipDate Range = 2 sequential days
Thanks So Much in Advance!
Bookmarks