Hi,
I have already a VBA code that creates a organigram based on a table.
One of the column is called "Entity" and actually one part of the code is this:
Code:
And works, if some rows have "PT" in the Colum "Entity" that shape will be fill with the color "RGB(192, 215, 155)".
What i would like, is to create a table in a diferent Sheet, for example "sheet2" where i have a Table (database) with 2 columns:
In cloumn A i would have the Entitys (example: PT, ENG, FR, SP, etc...) and in the column B for each Entity i will fill with a diferent color.
My goal is substitute the "PT" for column A and the RGB(192,215,155) for the correspondent color in column B.
Many thanks,
Goncalo
Bookmarks