Copy and paste rows from data onto sheets that match first column

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

Please Login or Register  to view this content.