Move Rows of Data into New Worksheets

[Closed]
Report
Posts
3
Registration date
Thursday November 16, 2017
Status
Member
Last seen
November 19, 2017
-
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!