+ Reply to Thread
Results 1 to 5 of 5

Show pictures, from hyperlinks in dropdown list.

  1. #1
    Registered User
    Join Date
    02-08-2019
    Location
    Ålesund, Norway
    MS-Off Ver
    Excel 365
    Posts
    12

    Post Show pictures, from hyperlinks in dropdown list.

    Hi guys,

    Is there anyone who knows (or can point me in the right direction) how I can show pictures from a table of hyperlinks (pictures stored locally). I`m making documentation for a project for my employer, and to do this manually will take a huge amount of time.

    Attached you see two images. The first one (printscreen1) shows the template i want to paste the picture in. THe sheet is organised in a way that when I select from my dropdown list "Kum ID" all relevant information is filled in the template. And in the same way i want my pictures also to be displayed.

    Picture two shows the table Im retrieving the information from.

    Link to workbook:
    htt ps:/ /drive.google.com/open?id=1ay1 o-NZ8n5X35DvvJa1FNvWlkPSLhUaj


    Is this possible, and if so, how do i do it?

    Printscreen1.JPG Printscreen2.JPG

    Thanks.

    Best regards
    Jan Inge
    Last edited by JanIngeO; 02-08-2019 at 11:02 AM. Reason: Pictures

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Show pictures, from hyperlinks in dropdown list.

    You are missing attachment(s).

    To upload files, you'll need to use "Go Advanced" button and then follow "Manage Attachments" hyperlink. It will launch new tab/window for managing file uploads.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    02-08-2019
    Location
    Ålesund, Norway
    MS-Off Ver
    Excel 365
    Posts
    12

    Re: Show pictures, from hyperlinks in dropdown list.

    They should be there now, sorrys!

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,770

    Re: Show pictures, from hyperlinks in dropdown list.

    Picture is worth thousand words, but sample workbook is worth million pictures

    I'd recommend that you upload desensitized sample workbook detailing your issue, and your desired outcome (manually created if needed).

  5. #5
    Registered User
    Join Date
    02-08-2019
    Location
    Ålesund, Norway
    MS-Off Ver
    Excel 365
    Posts
    12

    Re: Show pictures, from hyperlinks in dropdown list.

    Link is now in original post.

+ 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. Dropdown List Hyperlinks?
    By ptmuldoon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2018, 02:39 PM
  2. Dropdown list with Hyperlinks to specific Cells in different sheet
    By Fleur89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2017, 10:14 PM
  3. [SOLVED] Dropdown list of hyperlinks
    By psjpsjpsjpsj in forum Excel General
    Replies: 9
    Last Post: 10-16-2013, 09:15 AM
  4. [SOLVED] Link Pictures to a Dropdown List
    By JO505 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-14-2013, 08:53 PM
  5. Dropdown list (Data validation) with hyperlinks + friendly name
    By imagiine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-28-2013, 03:29 AM
  6. Replies: 5
    Last Post: 01-27-2013, 11:54 AM
  7. Replies: 0
    Last Post: 06-28-2005, 09:05 PM

Tags for this Thread

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