Hi Ninjas! I have a series of project plans, in table format, with an activity in Column A and a Start Date in Column B ... and a Project Name in Column A a few rows above the table. I need a way to generate a list that tells me what projects have tasks due this week. I'm already using the conditional formatting to flag the cells, but what I need to do now, is create an output report that lists my project names, and the activities and start dates for the current week, that can then be distributed each week ... is there an easy way to do that? I'm not familiar with macros and anything high tech, but any help you could offer would be greatly appreciated!
Thanks,
Ann
Thanks,
Ann