+ Reply to Thread
Results 1 to 13 of 13

I need help posting pics to dropdowns

  1. #1
    Registered User
    Join Date
    05-28-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    6

    I need help posting pics to dropdowns

    Hey guys.

    i need help adding pics to my dropdown

    i also dont know what department to post this in

    also can i post my file on here ?

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: I need help posting pics to dropdowns

    Welcome to the forum.

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Regards,
    Vladimir
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    05-28-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: I need help posting pics to dropdowns

    here is my file

    how it works

    what it is?- its a Cost calculator for building outdoor decks (porches and patios)

    So after doing a blueprint drawing i get the info from a drawing and enter them into the calculator. now the calculator is fully functional but can be much more effective and cool

    Row B is to enter the square footage of the deck and linear footage of the rail

    Row C is the drop-down of different types of Deck and Rail Material

    Row D is the different Material

    now you have to match up row C with Row D by counting how many steps you go down.

    I would like to eliminate this and just go straight to row D and Pick my material and style and the cost of that appear in Row C


    Also i would like to add Pics in Row G 7-21 so what ever i pick in Row D it shows a Pic in row G

    please and thanks for the help.
    i just learned excel a few months ago
    Attached Files Attached Files

  4. #4
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: I need help posting pics to dropdowns

    regarding pics go to this links.

    http://www.excelforum.com/excel-gene...l-value-2.html

    http://www.excelforum.com/excel-gene...lls-value.html

    in your Column C

    i think vlookup or index/match


    =VLOOKUP(D8,$A$32:$N$55,13)
    D8 is the material/style ->drop down list
    A32:N55 to table that contains the material/style and cost
    13 is the column where we can find the cost of that material

    or

    =index($N$32:$N$55,match(D8,$A$32:$A$35,0))
    n32:n55 is the column containing the cost of that material
    D8 is the material/style ->drop down list
    A32:A55 contains the names of the material/style.

  5. #5
    Registered User
    Join Date
    05-28-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: I need help posting pics to dropdowns

    Im so lost. maybe its late im gonna sleep

  6. #6
    Registered User
    Join Date
    05-28-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: I need help posting pics to dropdowns

    Can i Just pay someone to do this for me?
    I have a Few Calculators That i need to get done

  7. #7
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: I need help posting pics to dropdowns

    Some of the moderators and forum experts have consulting companies. I would start with Members List sorted from most posts to least posts (or best reputation to least) and contact a few people that have links to their companies in their signatures.

    Hope this helps.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  8. #8
    Registered User
    Join Date
    05-28-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: I need help posting pics to dropdowns

    I cannot access the members list, it says
    Sorry! The administrator has disabled the list of members.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: I need help posting pics to dropdowns

    Take a look at the Commercial services forum
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  10. #10
    Registered User
    Join Date
    05-28-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: I need help posting pics to dropdowns

    I looked, but nutting was there and couldn't post without being a paid member

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: I need help posting pics to dropdowns

    Can i Just pay someone to do this for me?
    Thats why I suggested that forum

  12. #12
    Forum Contributor
    Join Date
    05-09-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    259

    Re: I need help posting pics to dropdowns

    Try this from another member, helped me.

    I learned this trick from the video link on youtube "Excel Magic Trick 882" you can check that out too for excel 2007.

    I hope you use the index and match functions , if not then please learn it.

    So over here please refer to the file I attached in that thread. In the tab "Info" I inserted a bitmap object in cell A2 by steps (1&2):
    1- Place cursor on cell A2 and expand the cell according to the size of image then
    goto >> Insert >> Object >> Bitmap Image
    2- cancel the option if excel prompts you to draw the image.
    3 - Create a lookup list for images in tab Data
    4 - Create a named range using index and match function (the range should lookup for value in cell A2 in col info in the list in tab data.
    5. Select the empty bitmap image and then in the formula bar do ="named_range" and assigned the named range to the bitmap image.
    6. Now change values in the cell A1 info tab according to in the list in data tab.

    YOu are done.. All the best !!

  13. #13
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Central Ohio
    MS-Off Ver
    Excel 2000, and 2010
    Posts
    654

    Re: I need help posting pics to dropdowns

    I just had the same issue a few days ago.

    Here is the final example of the file. One word of caution, make sure the file names are an EXACT match. I spent a few hours tracking down some errors.

    Hope this helps.

    Jim O
    Attached Files Attached Files

+ 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