Select Data by Date Range, Delete Rest

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Learner,

This is quite a nice structured learning exercise and you would learn a lot
more by trying to do it first and then ask for comments.

So please try and lets see what you come up with.
 
Hi, Martin

I've tried... "Two rows" part and date range enrty are where I got stuck.
It's only a part of the code I'm working on. I'm already on the 11th page of
the code print-out. It was quite simple before it though. This is not my
homework :) and I am not making a living from it. I've learned more from
reading the posts than from the help file or MS tutorials. I'll try some
more... Thanks for your comment.
 
Back
Top