Make a new worksheet and copy rows [Closed]


I have a worksheet of data and I would like to copy all rows in the worksheet to new worksheets based upon location.

To elaborate, I have a worksheet full of data listed by school campus location. I want to extract all the rows of data for each campus location. I have 20 different campus locations, and 53000 rows of data to sort. I also want to name the new worksheets with the campus name where the data is coming from.

Can anyone help?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!