Pulling dates meeting certain criteria into different TABs

[Tom]

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

 

[Don Guillett]

Some reason you can't use data>filter>autofilter>custom>>>

 

[Tom]

Hi Don,

I was actually not aware of this function. I've been playing around with it
a bit, but I don't seem to be able to get it to do what I want.

Here's what I'm doing:

I go to the Advanced Filter Options (I use Office 07)

For the List Range, I hightlight all the cells I want to filter

For the Criteria Range, I have two cells set up on a different tab
a1 is =TODAY() and b1 is =a1+7

Then I have it set to "Copy to another location", but when I select a cell
in a different tab, I get an error message saying I can only copy filtered
data to the active sheet.

Am I doing something wrong here? The data can absolutely not be copied to a
different tab/sheet?

When I do copy to the same sheet, it copies all the data below my original
data... Doesn't seem to be sorted in any way. Just a copy of whats above.

Thanks for your help!
Tom

 

[Don Guillett]

Try autofilter instead of advanced filter.
With advanced you can copy to a NAMED RANGE.
If all else fails, send your file to my address below along with this msg
and what you want. I will take a look later today.