+ Reply to Thread
Results 1 to 6 of 6

Sortable list with collapsable thumbnails

  1. #1
    Registered User
    Join Date
    06-02-2020
    Location
    Sweden
    MS-Off Ver
    Office 365 32-bit
    Posts
    3

    Sortable list with collapsable thumbnails

    Hi all

    I´m new to this forum and not an excel expert.
    I´m trying to make a document that contains a long list of items. It should be possible to sort the list by data in different columns.
    I want to have the option to show or hide all the thumbnails for the items, preferably without any macro or VBA.

    First attempt of solving this is attached. By grouping of rows and letting pictures move and size with cells the show/hide function is ok, but the sorting only works for the first column I try. As soon as I sort on any other criteria it gets messed up.

    Any ideas on why?
    Or other better ways to get the two primary functions; table with sort and hide/show of thumbnails.

    Thank you
    Jojosoh
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Sortable list with collapsable thumbnails

    What do you mean by "messed up"? It seems to sort correctly on all four columns here ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-02-2020
    Location
    Sweden
    MS-Off Ver
    Office 365 32-bit
    Posts
    3

    Re: Sortable list with collapsable thumbnails

    If pictures are shown, and I play around with sorting the "Name" column everything works, but if I for example click on "year" and sort descending, the pictures no longer match the rest of the data.
    Is it only on my computer?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Sortable list with collapsable thumbnails

    Everything works for me UNTIL I collapse a group. The minute I do that, it all goes to pot.

    Merged cells should be avoided at all costs - they shouldn't even be possible, to be honest. They are far more trouble than they are worth.

  5. #5
    Registered User
    Join Date
    06-02-2020
    Location
    Sweden
    MS-Off Ver
    Office 365 32-bit
    Posts
    3

    Re: Sortable list with collapsable thumbnails

    Haha, true!
    I better focus on a way not using merged cells rather than trying to understand whats goofy with my example then.

    Thanks anyway!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Sortable list with collapsable thumbnails

    I think so. Good luck!

+ 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. Macro to Populate List of Files (with Thumbnails)?
    By neur0tic in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2015, 07:19 PM
  2. Replies: 6
    Last Post: 11-28-2013, 11:54 AM
  3. Replies: 3
    Last Post: 07-19-2010, 03:30 PM
  4. Thumbnails in Excel
    By sach0025 in forum Excel General
    Replies: 3
    Last Post: 04-19-2007, 04:25 AM
  5. [SOLVED] Sortable list of checkboxes
    By nvtd1 in forum Excel General
    Replies: 0
    Last Post: 12-19-2005, 06:10 PM
  6. Collapsable Rows?
    By Egon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2005, 02:05 PM
  7. sortable list
    By Greg in forum Excel General
    Replies: 2
    Last Post: 04-10-2005, 10:06 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