title: Creating a VBA script to copy and paste a cell into a range of cells from multiple sources
body: <p>Incredibly new to trying VBA. I want to take the following data and connect each row with data from another sheet. Basically I want each row of the initial list below to correspond with every location range from the second list. I'd like to know how to make it do it for any number of rows from the first list, as long as there is data in the row.</p>
  <p>Initial List</p>
  <p><a href="https://i.stack.imgur.com/xK8TN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xK8TN.png" alt="" /></a></p>
  <p>Location list</p>
  <p><a href="https://i.stack.imgur.com/86bXN.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/86bXN.png" alt="" /></a></p>