The enclosed file contains information on lorry journeys between locations, together with their departure and arrival times. The DATA is added to on a daily basis. An existing Macro 'FormatFilterSortAndPasteToSheet' is run weekly which filters and sorts the data, into each of the lettered tab.
As part of the Macro each ORIGIN is sorted to show number of times it 'ran' 'on time' and '% on time'.
What I would like is the same information under each tab, but for each 'DESTINATION' aswell. Hopefully this is a simple task for someone in the know.
When counting only include cells in the ACT ARR column that have a number in.
Thanks in anticipation. Kevin.
Bookmarks