Forum Discussion
Solved
Auto populate a cell with a table (column) on another sheet.
I have an application where I want to auto populate a cell with a drop down from a (column) table when a certain value is chosen in a third cell. This is so the User can only make a selection from the options that are limited to the specific Manufacturer they choose. Any thoughts?
Thank you very much. That is exactly what I needed! HansVogelaar
- So, that helped to get me started, but I'm still having trouble. I'll try to explain better. Cell C19 is auto-filled with information from Cell C8 which comes from a drop-down with info from another sheet on it. I want Cell E19 to be a dependent drop-down that returns a column from another sheet that changes with every different selection in C8. For example, when C19='SHEET2'AH2 then the drop-down will show only info from SHEET2 AH18:AH81. Please help. Thank you.
