title: populate an excel template with data from different Sharepoint views
body: <p>I am very new to Sharepoint and apologize for being very vague.</p>
  
  <p>I have an excel template that is filled with data by exporting different views from the sharepoint site. I am trying to automate the whole process so that the user has to only export the view and the template gets filled with required data automatically (and would prefer to completely by-pass the step to export).So the workflow is like this:</p>
  
  <pre><code>1. Select a view from the sharepoint site
  2. Export the view using "Export to Spreadsheet" option
  3. Save or open the .iqy file
  4. Repeat the steps 1-3 for 2 more different views
  </code></pre>
  
  <p>Now that I have the data that I need, I can start filling that data by looking the Project name and its corresponding data in export 2 and 3. All the views have the Project Name in common. I have to get the Risks name from export 2 and Completed Activities and Upcoming Activities from export 3 for a Project.</p>
  
  <p>Task: What I need is that my template should have a dropdown that is populated by retrieving the project name from the Sharepoint view, and puts data in Risks and Activities and other placeholders and adjust the number of rows as different Projects will have different number of Risks and Activities items.</p>
  
  <p>Any direction to achieve this will be greatly appreciated.</p>
  
  <p>Thank you. </p>