Excel Problem.jpg
In cell E10 the value in D10 will be multiplied by just one value from any of the list in Copper1 Copper2 Copper3 Press or Iron. I want to have the facility in E10 where i can select any of the product and after select the product i can select one of the value.
I NEED HELP CREATING THE FORMULA.
THANKS
TAIMUR
Hi, welcome to the forum
You cannot do that all in 1 cell, you would need to select the metal in 1 cell and the value in another cell.I want to have the facility in E10 where i can select any of the product and after select the product i can select one of the value.
Can you show some sample answers that you expect?
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
sample answer will be same as any simple calculation. Like multiplying 2 cells.
But you make me realize that I must insert another cell which will show what metal's price is used.
Before I didnt had that idea.
I will mark your reply as answered. If I had any problem will contact here again.
Thanks.
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks