I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this daily.
Move rows that have the same value in a column, into a new worksheet.
For example there may be 10 different values in column A. I want all rows containing the same value in column A to be extracted into a new excel workbook. In this case, there would be 10 different workbooks. Each workbook will contain all the rows that have the same value for column A.