Filtering and copying to multiple workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-3205565%22%20slang%3D%22en-US%22%3EFiltering%20and%20copying%20to%20multiple%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3205565%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20that%20is%20one%20table%20of%20all%20six%20lenders%20information.%20I%20want%20to%20filter%20out%20the%20information%20into%20a%20separate%20workbook%20and%20into%20their%20own%20individual%20tabs%20so%20that%20each%20month%20I%20can%20see%20what%20they%20are%20producing.%20When%20I%20have%20tried%20doing%20an%20advanced%20filter%20with%20%22copy%20to%22%20I%20am%20getting%20that%20I%20can%20only%20copy%20to%20an%20active%20worksheet.%20I%20even%20tried%20to%20compromise%20and%20just%20have%20it%20in%20the%20same%20workbook%2C%20just%20a%20different%20worksheet.%20I%20feel%20like%20there%20should%20be%20a%20way%20to%20do%20this%3F%20If%20anyone%20can%2C%20please%20advise.%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3205565%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3208204%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20and%20copying%20to%20multiple%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3208204%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1315816%22%20target%3D%22_blank%22%3E%40Bclickenger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recommend%20to%20do%20this%20with%20Power%20Query.%20You%20can%20import%20the%20main%20table%20into%20Power%20Query.%20There%20you%20copy%20the%20query%20six%20times%20and%20then%20filter%20each%20one%20for%20the%20specific%20lender.%20After%20that%2C%20you%20will%20get%20each%20filtered%20query%20in%20an%20individual%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a worksheet that is one table of all six lenders information. I want to filter out the information into a separate workbook and into their own individual tabs so that each month I can see what they are producing. When I have tried doing an advanced filter with "copy to" I am getting that I can only copy to an active worksheet. I even tried to compromise and just have it in the same workbook, just a different worksheet. I feel like there should be a way to do this? If anyone can, please advise. Thank you.

 

1 Reply

Hi @Bclickenger 

 

I recommend to do this with Power Query. You can import the main table into Power Query. There you copy the query six times and then filter each one for the specific lender. After that, you will get each filtered query in an individual worksheet.