title: Copy cell range and paste in another worksheet based on the date?
body: <p>I've scoured the interwebs for any kind of solution and I keep coming up empty so hopefully someone can help me out. I have two sheets, <code>Sheet1</code> and <code>Inventory.</code> In <code>Sheet</code>1, the user enters the date in B1. In range <code>C4:C200</code> I have a list of supplies and in range <code>D4:D200</code> a user enters the number of each of the supplies on hand. In Inventory, the list of supplies is in range <code>A1:A200</code>, and <code>b1:z1</code> list dates.</p>
  
  <p>I'm trying to create a macro that will look in Sheet1 for the date entered in B1, let's say <code>4/1/19</code>, copy <code>D4:D200</code>, then look in Inventory, find <code>4/1/19</code> in rows b1:z1 and paste the copied data beneath the correct date. So if <code>4/1/19</code> is in cell E1, the values would be pasted in E2.  </p>
  
  <p>While I'm decent with cell formulas and functions, I'm new to macros, so I'm not sure what to do.. Any help is greatly appreciated!</p>