Well it's pretty much just as the title says.
I have data with no blank spaces that will change daily, and the first column of each row is a route. Currently I have a sheet in which the user can select a route, and the sheet will populate all the rows in the data sheet in which the first cell matches that route.
What I would like instead is to have a sheet for each route, and to have all the rows be pasted automatically onto their own sheets based on the first value of data matching the sheet name.
Here's what I have so far....I'm new to VBA so I can follow tutorials and and guidance but once I can't find something specific I have to start asking questions. Thanks in advance for any help