I am working on a project that requires me to separate my spreadsheet into separate workbooks based on the value in a certain column (I). I need to copy the entire worksheet and format to a new workbook and then title it based on the value in column (I), and save it in a specified folder. I have attached a sample file. The code is also included in the file.
Your assistance is appreciated!