VBA - create separate spreadsheets from a filtered table
I think Power Query (aka Get &amp; Transform) could do this much more straightforwardly. Two queries one filtering for one thing another for the other they could live in the same or two different workbooks - refresh and save as, done. You could VBA the bit that saves them into separate books and names them in various ways I guess.