title: Scrape the data after giving date criteria using input box
body: <p>i need your help on the below code. I am scraping the data from the website based on date criteria. i have the code till it open the page  from the specific date which i give through input box, After that it moves to new page where i have data under headings Product(s), Manufacturer, NOC with conditions, Notice of Compliance date, Medicinal ingredient(s) and DIN(s). i need to copy that data into excel. Could any please help me with the code how to copy the data?
  below is my code till it enter the new page.</p>
  <pre><code>Option Explicit
  Sub Canada_Sorucing()
  
  Dim IE As Object, obj As Object
  Dim mynocFromDate As String
  
  Set IE = CreateObject(&quot;InternetExplorer.Application&quot;)
  With IE
  .Visible = True
  .navigate (&quot;https://health-products.canada.ca/noc-ac/index-eng.jsp&quot;)
  While IE.Readystate &lt;&gt; 4 Or IE.busy: DoEvents: Wend
  mynocFromDate = InputBox(&quot;enter from date eg.2016-10-01, yyyymmdd&quot;)
  IE.document.all(&quot;nocFromDate&quot;).Value = mynocFromDate
  IE.document.getElementsByName(&quot;action&quot;).Item.Click
  Do While IE.busy: DoEvents: Loop
  worksheets(&quot;Sheet1&quot;).Range(&quot;A:Z&quot;).ClearContents
  
  'from here i need to copy data under headings Product(s)    ,Manufacturer   ,NOC with conditions    ,Notice of Compliance date  ,Medicinal ingredient(s)    and DIN(s)
              
  End With
  IE.Quit
  End Sub
  </code></pre>
  <p>Please help.</p>