Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count occurences meeting criteria geebee Excel Worksheet Functions 8 July 17th 08 05:09 PM
pulling back dates that meet certain criteria Bruno Excel Worksheet Functions 1 July 21st 06 02:40 PM
count records meeting three criteria Laura Excel Worksheet Functions 5 December 21st 05 06:47 PM
how do i get "DGET" to take the first data meeting the criteria? Yardarm1 Excel Worksheet Functions 3 June 9th 05 08:21 AM
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 John Higgins Excel Worksheet Functions 2 December 22nd 04 02:19 AM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"