Hello,
I have a workbook that has 9 tabs. I would like to have a VBA that automatically filters tab 2, for each of the names in column B. Then, it would save all the tabs in the workbook with the name that the list is filtered for on tab 2. All the workbooks would contain the same data, the the difference between each workbook would be the filtered list on tab 2.