Hi,
i want to describe a variety of detailed processes each with an excel sheet. I have created therefore an excel template considering the properties of a trigger, an input, a step, an output etc. - just as a simple list, each section with a new row for each property and the sections divided by an empty row.
But since I want to deal with different processes I want a drop down menue at the top where I can choose how many triggers, inputs, ... the process has. Then I want the process desciption to contain the number of inputs, outputs... I also want to be able to change the number of inputs, etc. while working with the sheet.
I cant really imagine how this is supposed to work with Macros (especially after editing , what other possibilities do I have?
thanks in advance!
i want to describe a variety of detailed processes each with an excel sheet. I have created therefore an excel template considering the properties of a trigger, an input, a step, an output etc. - just as a simple list, each section with a new row for each property and the sections divided by an empty row.
But since I want to deal with different processes I want a drop down menue at the top where I can choose how many triggers, inputs, ... the process has. Then I want the process desciption to contain the number of inputs, outputs... I also want to be able to change the number of inputs, etc. while working with the sheet.
I cant really imagine how this is supposed to work with Macros (especially after editing , what other possibilities do I have?
thanks in advance!