Visio 2003 Professional- 1- LInk Data from Excel 2-Export this Data to Excel
This is 2 parts. I have a library of shapes (stencils) that I'd like to link data to from an Excel file (Product & price).
When I create the new drawing, I'd like the data from the "shape" (product, cost) to transfer to an Excel sheet.
Basically, I'm using Visio 2003 Professional as a basic CAD program and am exporting it for job costing from the design. Here's screenshots of what I'd like it to do.
Full screen: http://screencast.com/t/FWbTNnhoN1
The "Result" image shows a window w/in Visio, but that doesn't matter as much. Just that it will add the products and the total.
****I'd like to add the product data in continuously as new products are added, and I'd like to update the products as the pricing is changed.