+ Reply to Thread
Results 1 to 2 of 2

Make a slider automatically slide

  1. #1
    Registered User
    Join Date
    04-09-2020
    Location
    Birmingham
    MS-Off Ver
    2010
    Posts
    1

    Make a slider automatically slide

    Ok this is an architectural issue sheet example.a list of all drawings issued and a history of all past revisions. Im using a program to push all the revision info into the grey area (see attached) . What i want is for my slider to always shown the latest 15 revisions. Is there a way to make the slider recognise the highest column to contain data, and then minis 15 columns from that to always show the latest 15?

  2. #2
    Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    310

    Re: Make a slider automatically slide

    Hi mountain1985,

    Not 100% I understand, but if you have a long list of revisions in the grey area and you want simply to show the latest 15 revisions in the green spot, then:

    How about inserting a pivot table where you have the green box. You then could use the 'Value filter' > 'Top 10 Filer'.
    In the dialog box, set the number of records to 15 and choose the revision date as the 'by' field.
    You then would need to refresh the data after more revisions are added. Under Pivot Table Options > Data tab, you can tick 'Refresh data when opening the file. If you need the data more frequently refreshed, you need to do this manually or could use a VBA code.

    Alternatively, you could use a VLOOKUP formula combined with RANK formula. First row you lookup the revision with the RANK 1 in the revision date, second line RANK 2...

    Hope this will give you some ideas.

+ 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] Create a slide oval slider form control
    By Rocky2013 in forum Excel General
    Replies: 3
    Last Post: 05-18-2017, 08:10 PM
  2. Inserting Slides from Another Presentation Removes Slide Numbering & Footer on Slide
    By PSSMargaret in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 05-15-2016, 09:21 AM
  3. PowerPoint to automatically update while in slide show mode
    By angel2903 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2015, 12:43 PM
  4. How to make slider adjust for percentages less than 1%.
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2014, 03:06 PM
  5. MAcro to paste excel table into PPT slide automatically
    By sameeru in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-12-2013, 05:51 AM
  6. Make a powerpoint slide that scrolls down a large image.
    By 111StepsAhead in forum PowerPoint Formatting & General
    Replies: 2
    Last Post: 03-18-2013, 03:16 AM
  7. hOW DO i MAKE A COLUMN SLIDE ALONG WHEN I'M SCROLLNG SIDEWAYS
    By LN in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-06-2006, 01:40 PM

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