Hello,

I generate a large report every day with different information for projects
my company is working on. Currently there's about 120 projects in the report.
The report looks something like this:

A: Project Number
B: Project Name
C: Budget Year
... and so on

Then towards the end is lists forecast and actual dates for milestones in
the project.

AA: Milestone1 Forecast
AB: Milestone1 Actual
AC: Milestone2 Forecast
AD: Milestone2 Actual
etc.


What I'd like to do, but can't figure out how is have Excel go through all
the dates, and pull all dates that are overdue into a seperate TAB, along
with the Project Number. Then the projects that are due within the next 7
days into a different TAB.

Since I don't have any programming skills, is this possible with just
formulas and macros?

Thanks,
Tom