title: Excel Macro: Open Sheet in Background and Execute Analysis in Background Sheet
body: <p>I am relatively new to the true power in Excel - Macros/VBA and have been tasked to set up the financial model for a million dollar project. I am able to set everything up and have it run smoothly, but there's too much manual input involved. I would like to seek simplification through the power of VBA.</p>
  
  <p>This is my dilemma:</p>
  
  <ol>
  <li><p>I need to be able to individually double-click on a specific set of cells (in a Row), which will open up a file window that allows me to select a EXL file.</p></li>
  <li><p>Once I select the file, that file should be preferably opened in a temp status (not visible, but I can run functions and pull info from it).</p></li>
  <li><p>I will then need the macro to go into that opened sheet, conduct a simple SUMIFS function, and record the outcome in a column of the current sheet I'm working from.</p></li>
  </ol>
  
  <p>I've been doing some Excel tutorial on Lynda in hope to seek the answers there, but I think the complexity of this request demands the knowledge of a true master.</p>
  
  <p>Any help will be greatly appreciated! I would imagine this could be a nice little challenge for those who seek it :)</p>
  
  <p>Sincere thanks,</p>