I'm currently exporting a daily report that lists due dates out to the next month. The dates are all listed in one column. I then sort the worksheet by date ascending and only keep the rows that contain the following criteria: dates in the past, today's date, and the next 5 consecutive dates after today's date. All other rows get deleted. I believe a macro would be the way to go, but my only issue would be correctly programming "the next 5 consecutive dates" condition. For example, say today was 8/30, and the next 5 dates that show are: 8/31, 9/4, 9/5, 9/6, and 9/7. My fear is that the macro I'd create would simply go out five calendar days to 9/4 and delete everything after 9/4 when in fact I need to go out to 9/7. And since this is a live table, dates are constantly changing day-to-day. Any input will be much appreciated.
Will be used on a PC with Excel 2003.
Sample worksheet to follow shortly....
Ex1.xlsx
Bookmarks