I have 2 cells with data validation(lists). C7 and E7. There are 4 choices in C7.
Based on what option i choose in C7 i need E7 to bring up a list that is associated with that option.
For example... if i have option 1 chosen in C7, i need the range of data in F75:F114 to appear in E7... if option 2 is chosen in C7, i need the range of data in G75:G125 to appear...
Let me know if you can help!
Bookmarks