Julmust Jaeger
New Member
- Joined
- Jul 20, 2022
- Messages
- 20
- Office Version
- 2016
- Platform
- Windows
Hello,
I am trying to figure out how to loop using Autofilter so that I can create specific worksheets based on column values (copying all relevant rows) and then save each worksheet as it's own work book.
My data is essentially columns (A:P) and Rows (1:2000, with Row 1 being headers).
In Column P, I have company names. I would like to Autofilter based on company names, then copy and paste all filtered rows to a sheet that matches this company name...and then loop through this until all companies have their own worksheets populated with relevant data. Finally, I would like to save each worksheet as it's own workbook named according the company.
Related, I have tried the example in this link (VBA Question - Filter, copy, and paste to new worksheet), but keeps generating errors.
Thanks!
I am trying to figure out how to loop using Autofilter so that I can create specific worksheets based on column values (copying all relevant rows) and then save each worksheet as it's own work book.
My data is essentially columns (A:P) and Rows (1:2000, with Row 1 being headers).
In Column P, I have company names. I would like to Autofilter based on company names, then copy and paste all filtered rows to a sheet that matches this company name...and then loop through this until all companies have their own worksheets populated with relevant data. Finally, I would like to save each worksheet as it's own workbook named according the company.
Related, I have tried the example in this link (VBA Question - Filter, copy, and paste to new worksheet), but keeps generating errors.
Thanks!