If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
list on new sheet
CAN SOMEONE HELP
HERE IS MY DATA A B C D Name CofC Date FDA OTMR B------ PHIL 17-Aug-06 17-Feb-06 17-Aug-06 COMPLETED 10-Jan-06 15-Jan-06 B------- BOB 30-Aug-06 28-Feb-06 30-Aug-06 COMPLETED B----- Steve 05-Mar-06 05-Sep-06 05-Mar-06 COMPLETED B----- Dave 14-Dec-06 14-Jun-06 14-Dec-06 COMPLETED B----------- Wayne 10-Mar-06 10-Sep-06 10-Mar-06 COMPLETED and so on column c and d are activities the person has to complete and the date under this is the latest it has to be completed, along the completed rows are the dates they were completed. What i have it doing using cond format is background goes black of the cell if within 60 days and yellow if it has a completed date in. what i am after on a seperate sheet is a list of all that are within 60 days and not been completed like this B------- BOB 28-Feb-06 FDA B----- Steve 05-Mar-06 OTMR PLEASE HELP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using first list box to populate choices in second list box | Giz | Using Forms | 2 | October 25th, 2005 04:51 PM |
Using a relative SHEET reference for source data in a chart | James | Charts and Charting | 6 | August 16th, 2005 05:07 PM |
E-mail Display name is wrong | Jane Nangle | Contacts | 9 | February 4th, 2005 10:05 AM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Drop Down Menus | Dude | Worksheet Functions | 1 | June 24th, 2004 12:25 AM |