Hi Xperts,
I have an excel workbook with the following:
1) Sheet-1 : List of all unique items
2) Sheet-2 : List of all mappings (many to many) between the items (from sheet-1)
[The mapping between two items is unique however]
Example:
Sheet-1:
Table
Chair
Purse
Phone
Pen
Sheet-2:
Table Chair
Table Purse
Chair Purse
Chair Phone
Chair Pen
Purse Table
...
The value on the left in sheet-2 is a child of the value in the right of sheet-2
Any way to automatically create a chart using macro/wizard etc... ?
I tried the org chart wizard but stuck with the prob that it does not allow two parents - one child relationship.
Please help urgently.
Prasad