1 Reply Latest reply on Oct 29, 2012 11:50 AM by Deepak Gupta

    Linking Custom Properties to Excel

    Ian Hooton



      I am looking for a little help, not sure if what I would like to do canbe done.


      I have created custom properties that the user selects various departments and projects from (lists stored on a central excel file).


      What I would like to do is that when a drawing is created the existing custom properties are populated in to the drawing, this is easy, but what I would like to do is also have for example the department number appear on the drawing, but only by using a lookup on the department name. (each department has a different number, this is stored also on the central excel file). Then I would like depending on the department number colour a rectangle with a specific colour.


      I can do this no problem in excel using Vlookup and condition formating, but how can I translate this into a title block?