i have a sheet ("B")containing a range of values.

One of these values is dates(column x).

I need to run a macro, that will pick all rows from sheet "B", within date "date1" stated in a cell in Sheet "a", and "today" copy these, and paste them to sheet "C".

Anyone who has some simple coding for that?