Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count occurences meeting criteria | Excel Worksheet Functions | |||
pulling back dates that meet certain criteria | Excel Worksheet Functions | |||
count records meeting three criteria | Excel Worksheet Functions | |||
how do i get "DGET" to take the first data meeting the criteria? | Excel Worksheet Functions | |||
COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions |