Hi guys, I'm new in this forum but I desperately need your help!
I’ve attached a file so that maybe it’s easier to understand. Basically, I’m creating an excel to better catalogue our tools that we buy from supplier. In the first sheet there is recap of the orders. In second sheet there are some tools divided for supplier’s name, type, name and code.
When in the first sheet I select the name of the tool from my drop-down menu (as you can see), I want that, instead of the name I chose, I see written the code of the item.
So I was thinking if it would be possible to connect the cells D3 with C3, D4 with C4, D5 with C5 etc.
Can someone help me please?
Thank you so much
Martina
