Separate Timetables into sperate sheets

Hi everyone,

Not sure this is even possible but here goes!

Is there a way to take the data from the attached timetable and separate it into separate timetables based on the stations?
I have a macro that will put all the data on to a master sheet if needed but then need it breaking down into the different routes based on which stations have times inputted?

The routes should be broken down based on the start and end station - so it doesn't matter if some stations are missed on the same route. E.G Station A - D via B & C will be in the same timetable as A - D direct.

I have attached the raw data and an example of how I would like it to look. They don't have to be on the same sheet.

Many thanks.

Hi, I'm sure it can be done but you I suggest you include and explanation and a final layout sheet for a station or statins with the desired result.
It will paint a better picture than words

Okay, will see what I can do.
The files you sent are pre-Office 2007 and you're using 2010.
And there are no macros, which macro did or so you use?

This still doesn't explain why you've saved your files as xls files

The file is also smaller when saved as xlsx file