+ Reply to Thread
Results 1 to 5 of 5

Keep Service Descriptions on the Service Tracker sheet same as Vehicle Interval Schedule

  1. #1
    Banned User!
    Join Date
    06-18-2021
    Location
    Peru
    MS-Off Ver
    2010, Microsoft 365
    Posts
    431

    Keep Service Descriptions on the Service Tracker sheet same as Vehicle Interval Schedule

    Hello,

    There is code to sort the table in the Vehicle Interval Schedule sheet which may change the order of the Service Descriptions. I would like the order of the Service Descriptions to be the same on the Service Tracker sheet.

    Is this possible to do and remain dynamic?

    Thank you very much for your help

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Keep Service Descriptions on the Service Tracker sheet same as Vehicle Interval Schedu

    This in "Service Tracker" B7

    =Table3[@Col1]

    ??
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Banned User!
    Join Date
    06-18-2021
    Location
    Peru
    MS-Off Ver
    2010, Microsoft 365
    Posts
    431

    Re: Keep Service Descriptions on the Service Tracker sheet same as Vehicle Interval Schedu

    Excellent thank you very JohnTopley. Will the table add these rows as the table on the Vehicle Interval Schedule sheet table grows?

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Keep Service Descriptions on the Service Tracker sheet same as Vehicle Interval Schedu

    Yes it should do..

  5. #5
    Banned User!
    Join Date
    06-18-2021
    Location
    Peru
    MS-Off Ver
    2010, Microsoft 365
    Posts
    431

    Re: Keep Service Descriptions on the Service Tracker sheet same as Vehicle Interval Schedu

    Thanks again for your help.

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to Insert Vehicle Services per Service Group on the Service Log Sheet
    By BillySpivy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-16-2022, 06:34 AM
  2. [SOLVED] Formulas to Add Miles to Service Descriptions Based on Vehicle Interval Schedule
    By BillySpivy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2022, 11:17 AM
  3. Check if vehicle is within service and highlight
    By GHI1968 in forum Excel General
    Replies: 4
    Last Post: 07-03-2018, 08:50 PM
  4. Vehicle service interval calculator
    By Ariane001 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2016, 04:00 AM
  5. Formula to check for vehicle service done
    By Noorking in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2014, 04:58 AM
  6. Replies: 3
    Last Post: 11-24-2013, 09:54 PM
  7. Roll up totals for service descriptions
    By jmjt in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-18-2012, 08:55 AM

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