+ Reply to Thread
Results 1 to 2 of 2

Thumbnail or link to thumbnail in row.

  1. #1
    Registered User
    Join Date
    04-11-2008
    Posts
    1

    Thumbnail or link to thumbnail in row.

    Hey all,

    My first post here, so be gentle.

    Anyway, here's what I'm trying to accomplish. First of all, what I do is I design playgrounds and the equipment in them (big play structures you see at schools and in city parks), maybe as many as 10 a day. So over the past few years I've got thousands of files in a wide range of prices and sizes. I'm attempting to make it easier for the sales force here to find drawings that I've done in the past in defined price ranges. That way we don't have to re-invent the wheel every day.

    My plan is to use Excel to have columns of set price ranges, since most of the time a customer has a certain budget and we, of course, want to us all of it. So the salesman would first look at the column within his price range and then be able to see a thumbnail of the particular project to see if it is the type of structure the customer is interested in.

    Here's the nub of it. I know how to link to the existing PowerPoint file on our server, but they can be big and that takes time to bring them up, so is there a quick (simple) way to display, or even link, to just a thumbnail of the PP file in an Excel row???

    TIA
    Ralph

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475
    Good evening,
    Here is one example of using a drop down menu to select a picture and get a price, you could modify it to select a price to get the picture
    Click on the blue cell to select the picture, the pics are on sheet3 including the price list,
    http://www.excelforum.com/attachment...4&d=1205371421

    This comes from this thread that has other links to threads with the same topic
    http://www.excelforum.com/showthread.php?t=636627

+ 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