PDA

View Full Version : Multidimensional array problem



rumceisz
04-23-2012, 08:17 AM
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

Bob Phillips
04-23-2012, 10:38 AM
I am confused as to what bits you want completed, there seem to be many, and what data it is based upon.

Bob Phillips
04-23-2012, 03:21 PM
Or not, as it is cross-posted at CodeCage (http://www.thecodecage.com/forumz/microsoft-excel-forum/212502-multidimensional-array-problem.html)and ExcelForum (http://www.excelforum.com/excel-programming/826767-multidimensional-array-problem.html)

macropod
04-23-2012, 09:23 PM
Also cross-posted at: http://www.tek-tips.com/viewthread.cfm?qid=1681228
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184