I have a very large excel database of properties I own and properties i want to buy. The program a ton of VB
routines and that calculate property values, financials, etc. The properties are defind as A,B,C,D,ETC. wereas Cel A1 = A will equal a specific property that is translated to all the program menus in the program. Example:
on sheet 12 Cel A1 = A; B1 is the Directry Path for the picture of that house (7 Pictures). On my Cover letter I have property data and Smartart captions. currently, I haveto click on the caption and insert the picture manualy. How can i make this Automated? When Cel A1=A that picture is in my caption.
Thank you very much for any help