Dear All,

I have pulled a massive report and it has a State column. I would like to run a macro that creates a new worksheet for every time the value changes in the cells in that column. The worksheet would be named by the state (new value). So, when the value in the State column is Alabama it creates a worksheet named Alabama with all of the data associated with it. When it changes to Arkansas, a new sheet is generated.

Any ideas?