Copy all Rows in excel sheet only if specific cell = today's date
<p>I'm knew to vb scripting for excel and cant seem to find code that will help do what i want. maybe its how im wording my search criteria. </p>

<p>Sheet 1 is an input sheet which saves data into sheet 2 every day. There is a cell that holds the current date.</p>

<p>So sheet 2 just collates and saves everything entered. </p>

<p>Each day there are several rows saved into sheet 2.
I need a button on sheet two that only selects the rows that have today's date and copies the content. I just need that data copied so i can then paste this into off clipboard into another application.</p>

<p>Can anyone help? im using office 2016.</p>

<p>Thanks</p>