Good Morning,
I need to be able to choose an item from a drop down and have cells fill in. Here is what I have.....
On Sheet 1
Example 1.jpg
On Sheet 2 (the one that needs to fill in depending on what is chosen in a drop down)
Example 2.jpg
For example: I need to be able to choose "ZTSCT MSTD" from a drop down menu and have Sheet 2 fill in to look like this.
Example 3.jpg
Does anyone have an idea how to make that happen? This would save so much time at work I would be a hero.
Thank you in advance to anyone who tries to help.
I hope you all have a wonderful day!
Bookmarks