Pulling dates meeting certain criteria into different TABs
 

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

Pulling dates meeting certain criteria into different TABs
 

Some reason you can't use datafilterautofiltercustom
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom" wrote in message
...
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

Pulling dates meeting certain criteria into different TABs
 

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" wrote:


Some reason you can't use datafilterautofiltercustom
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom" wrote in message
...
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

Pulling dates meeting certain criteria into different TABs
 

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.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom" wrote in message
...
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" wrote:


Some reason you can't use datafilterautofiltercustom
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tom" wrote in message
...
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