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 ?
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 ?
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
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
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.
Im so lost. maybe its late im gonna sleep
Can i Just pay someone to do this for me?
I have a Few Calculators That i need to get done
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.
I cannot access the members list, it says
Sorry! The administrator has disabled the list of members.
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
I looked, but nutting was there and couldn't post without being a paid member
Thats why I suggested that forumCan i Just pay someone to do this for me?
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 !!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks