I have the following problem: I made a form feed for my HR department colleagues. This excel contains a sheets which is a form for the new colleagues. When the HR colleague choose a postion and knock the button, the macro fill the form with data related to the chosen position.
But there is a part which I couldn't achieve: there are Tasks, Subtasks, Sub-Subtasks in most of the positions and I'd like to list these strucuture in the form like this (see attached xls Template sheet):
I tried to use multidimensional array but it didn't work, I got error maybe I missed something.
Can you please suggest?
The most easy to understand is to see the attached excel file Template sheet!
+ question: I'd like to fill an array from a column but there are many redundant values. How can I make an array from the column with unique values? See sheet1!
The excel file is attached here:
Thanks in advance!