Jul 18 2019 07:07 AM
I'd like to be able to create the setup of one sheet based on a reference sheet. For example, I have an assessment that has tasks with associated items. In the reference sheet, I would like the individual to input the number of tasks, the associated number of items with each task, and have these values create the correct number of columns/headings on the secondary sheet (Task 1, Task 1 - Item 1, Task 1 - Item 2, Task 2, etc.). It may be a matter of the reference sheet causing the secondary sheet to make certain columns visible/hidden, but I'm not sure how to do this. I'd appreciate any help.
Jul 18 2019 07:22 AM