title: Looping Excel Macro
body: <p>I'm not overly familiar with macros on Excel VBA, so was looking for some help on the following:</p>
  
  <p>Creating a template where the user will enter an unlimited number of products and users, creating a matrix with products along the top and users along the left hand side.</p>
  
  <pre><code>          Product 1 Product 2   Product 3
  </code></pre>
  
  <p>User A<br>
  User 1<br>
  User 2<br>
  User 3      </p>
  
  <p>There they will use "x" or 1 and 0 to signify what products are assigned to each users (can be multiple products). From there I need a macro (or potentially a formula I'm told could work) to populate another tab with one line for each user/product combination. I would need a looping macro to cycle through each line as there is no restriction on how many users/products the person using the template may enter).</p>
  
  <p>User (column 1)     Product (column 2)</p>
  
  <p>User A  Product 1</p>
  
  <p>User A  Product 2</p>
  
  <p>User 1  Product 2</p>
  
  <p>User 2  Product 3</p>
  
  <p>User 3  Product 3</p>
  
  <p>User 3  Product 2</p>