title: Copy Cell to Specific Range with Math
body: <p>In the example in the image, I have fields B2-B11 filled. I created a formula for C4, and I want to paste it from C4 to C9. But I need the range to change depending on what the last B cell filled is. So if it was B2-B14, it should paste from C4 to C12. I hope this makes sense. Any help is appreciated, let me know if I can clarify anything! I'm struggling to figure out how to make this dynamic in vba.</p>
  
  <p>See the image for an example:</p>
  
  <p><a href="https://i.stack.imgur.com/A0BlK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/A0BlK.png" alt="enter image description here"></a></p>