+ Reply to Thread
Results 1 to 1 of 1

Tweaking existing Macro to give info by DESTINATION

  1. #1
    Registered User
    Join Date
    07-24-2007
    Location
    London, England
    MS-Off Ver
    Office 365 ProPlus
    Posts
    80

    Tweaking existing Macro to give info by DESTINATION

    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.
    Attached Files Attached Files
    Last edited by rushdenx1; 06-07-2010 at 09:15 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1