Forum Discussion
Filtering and copying to multiple workbooks
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...
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.