I am trying to create a macro that will copy rows that fall within a certain date range to be copied into a new worksheet.
On worksheet 1, I have the date selection criteria (via dropdowns) and the selected "To" date is placed in C1, the "From" date is placed in C2.
Worksheet 2 contains the data. The column containing the dates is D. There are 7 columns of data per row.
Does anyone have any ideas on how I can go about doing this?
thanks.
ambra19
On worksheet 1, I have the date selection criteria (via dropdowns) and the selected "To" date is placed in C1, the "From" date is placed in C2.
Worksheet 2 contains the data. The column containing the dates is D. There are 7 columns of data per row.
Does anyone have any ideas on how I can go about doing this?
thanks.
ambra19