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.