Hello,

I would like to create macro which will autofill organization tree/
diagram.

I have database of Employees:

Name | Surename | Job
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
John | Smith | Manager
Eve | Brown | Process Engineer
Joe | Locke | Product Engineer
....
....
....

I need to build organization tree/diagram in Excel. You can insert
that object from Menu.

It looks something like that:

_____________________
| PRODUCT MANAGER |
| John Smith |
-------------------------------------
|

----------------------------------------------------

| |
______|______________ _____________________
| PROCES ENGINEER | | PRODUCT ENGINEER |
| Eve Brown | | Joe
Locke |
-------------------------------------
--------------------------------------

People from all departmens will have to update those diagrams. Some
departments have abot 50 empleeys. I would like to make it easier, and
faster to operate for all people who will be using this file.

I would like that data will be put into the diagram only by clicking
on the name in the database's table and then on Object. Something on
the "drag and drop" basis.

Anyone have an idea how do it?

Thank you for all advices.

Best regards,
Bartosz Dlugokêcki