Copy Worksheet to New Workbook based on Cell Value

0

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!

Answer
Discuss

Answers

0

Sort by the column then copy each group forthwith.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login