Hello,
I have attached an excel file to help explain what I am trying to do. On Sheet1 I have a drop down list that allows the user to select PartA, PartB, PartC, or PartD. On Sheet2 I have listed the Binders that correspond to each Part (in red). I have also listed the locations for each of the binders (in yellow).
Here is what I would like to have happen. When the user selects a Part on Sheet1, I would like the table (in green) to automatically update so that all the binders and the binder locations update each time the user selects a different Part from the drop down list.
Note: I just put the ‘green table’ in the spreadsheet to help explain what I want to have happen.
Any help would be greatly appreciated.
Bookmarks