<colgroup><col width="69"><col span="7" width="64"><col width="71"><col width="85"></colgroup><tbody>
I am hoping to learn how to setup a unique list of vendors (VendorList) from a list using a named range, then loop through that list in a VBA macro that is using filters. Each worksheet is named after the vendor and so is the table. So worksheet Vendor1 table Vendor1. My main sheet is called Orders and where we import all of the items to be ordered for the day. I know what vendors I have but not all will be ordered daily. I will add sheets to the workbook as we add vendors and I thought that this should be fairly simple but the simplicity has alluded me. We then do a print of each worksheet that had an order for the day. Thank you in advance.
So basically loop through unique list of vendors VendorList and do this code for each i in VendorList
ActiveSheet.ListObjects("Orders").Range.AutoFilter Field:=2, Criteria1:= _
Do While Range("Orders") <> ""