Creating organizational charts using VBA code?
My problem
Our company has several hundred UPC's numbers in an Excel spreadsheet. Each number (obviously) corresponds to a office device (i.e. monitor, keyboard, etc.). They want to be able to (when an UPC number is entered) have a chart/graph/picture be drawn to include the new device has been added to the inventory
For example... if I have three monitors, a keyboard, and a mouse that are new they want those added to this organizational chart. The UPC numbers have some relivence, but not a lot. (i.e. All monitor UPC numbers begin with "5"). Is there anyway, using VBA, to code a cell, so that when a new UPC number is entered, Excel will draw a box/shape/symbol to represent this addition? Would it be better to use another MS program such as Access?
|