Forum Discussion
Making drop down menu represent an item & cost
Hello. What I need to do is create a drop down menu that has specific items in it that also reflect a cost. Then be able to take that cost and multiply it by another cell. Example Cell A1 is a dro...
Haytham AmairahOk I got that part. My Excel didn't have table design in the ribbon for some reason. If you don't mind could you look at my Excel? On Sheet1, Cell A19 I need the drop down to select equipment from the Equip Page, Cell A1 (equipment description). I also need for the rate on Equip, Cell B1 to go to Sheet 1, Cell B19. This would make it so when I select a piece of equipment the rate for the equipment would automatically go to Sheet1, Cell B19. Thanks for the help. I have watched countless You Tube Videos and im spinning my wheels.
- Hi Haytham,
I know this was a while ago but you may be able to help.
I've got your above solution working, but what if my columns are not side by side and three are columns in between that I wish to ignore?
Example, I have my description in column B but my costs are in column E
