Dear Experts! Your suggestions are appreciated. Here's the sheet layout.

Column A contains names;
Columns B through CW (99 columns) contain dates in MM/DD/YY format;
Even rows have actual dates, uneven rows - target dates (two rows per name);
Dates are filled out unevenly, some rows may have 50 entries, some only 5,
but there are no blanks between row entries;
Target dates are calculated when the actual dates are entered, so both dates
are always present;
Number of used columns is fixed, number of used rows is not.

VBA code needed to do the following:
Promt the user to enter the start and end date;
Check actual dates (even rows) for a specified date range;
If actual date falls within the range, keep it and keep the target date
right below it;
Delete the rest and shift everything to the left;

Thank you for your help!