Visio Guy

Visio Discussions => General Visio => Topic started by: jebuxx on December 16, 2014, 09:53:24 PM

Title: Linking data to shapes - making a more dynamic form
Post by: jebuxx on December 16, 2014, 09:53:24 PM
Please see the attached PDF & JPEG
Visio file; sheet 1 is a drop down list of all the items in column A on the spread sheet.
              I know I can get all the other sheets, 2 through 18, to populate  as their columns info using IF statements.
Question; can this be done more simply by linking the Excel data file?
       

Title: Re: Linking data to shapes - making a more dynamic form
Post by: Yacine on December 17, 2014, 07:05:57 AM
Hi,
The way I interpret your uploads, you want to update several shapes (their data) in a drawing, but excel row by excel row.
Andrei has started a similar project (http://visguy.com/vgforum/index.php?topic=6051.msg24551#msg24551)
The topic is not closed yet, but my be you can get a first impression on how to solve it.