Ok. I've taken a different approach to this issue. The first Command button stays. The second command button should be disregarded. I have provided a Power Query Solution. Power Query is part of Excel starting with Version 2010. Since you are running 2013, you will need to download the add-in available from Microsoft. Here is the Mcode for the solution.
First I loaded each of your tabs into Power Query and then merged the two tables based upon the SO Order.
let
Source = Table.NestedJoin(Table1, {"SO Order#"}, Report, {"SO Order#"}, "Report!_FilterDatabase", JoinKind.LeftOuter),
#"Expanded Report!_FilterDatabase" = Table.ExpandTableColumn(Source, "Report!_FilterDatabase", {"Sold To Customer Name", "Shipped To", "Item Description", "PO#", "LotNo/Roll/Batch", "Carton or Size", "Shipper", "Pkg ID/Tracking#", "SO Order#"}, {"Sold To Customer Name", "Shipped To", "Item Description", "PO#", "LotNo/Roll/Batch", "Carton or Size", "Shipper", "Pkg ID/Tracking#", "SO Order#.1"}),
#"Removed Duplicates" = Table.Distinct(#"Expanded Report!_FilterDatabase", {"Item Description"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Duplicates", each ([Sold To Customer Name] <> null))
in
#"Filtered Rows"
If you are unfamiliar with PQ, then look at the two links in my signature in Post #2 for a complete explanation and how to employ this. It is very fast and fairly simple to learn. Your file with the PQ solution is attached.
Bookmarks