Okay, let's pretend I didn't really understand most of what was on that page...
In my B1 Cell, the user selects Option1, Option2, or Option3. Upon doing
so, this should trigger and auto-population of the cells in column A,
starting with A5 and going down as long as the Option list is.
After reading that website, I have no idea where I'm supposed to put any
formulas. In my mind, it's a simple "If I choose X, then Y happens." I just
don't have the knowledge to make it happen. That's where I need the help.
"Luke M" wrote:
Check out Debra's site on creating dynamic validation:
http://www.contextures.com/xldataval02.html
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Del" wrote:
I'm building a simple planning template, but I want it to be
multi-functional. Here's what I'd like it to do:
INPUT SHEET: User is prompted to select task from a dropdown list. List has
three options [OPT1, OPT2, OPT3]
When user selects a particular option, a column on that INPUT SHEET is
automatically populated with list of tasks that need to be done for that
option. Option 1 has 10 tasks. Option 2 has 5 tasks. Option 3 has 20 tasks.
Each task list is in a separate sheet (TASK SHEET) within the workbook that
will be hidden for users.
How do I make this happen - and can I make this happen with different sized
task lists?
For reference, I would want the Options data to begin in Cell A5 of the
Input Sheet.