Multidimensional array problem

Hi All,

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):
SubtaskX
Sub-SubtaskZ
description
Sub-SubtaskU
description
description
.....
SubtaskY
Sub-SubtaskP
desc..

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!

Thanks in advance!

Best regards,
Rumi
Attache

AttachmentSize
HR_data.xlsm103.54 KB
Vishesh's picture

Its a bit involved. Happy to

Its a bit involved.
Happy to help via
http://excelexperts.com/contact