A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

list on new sheet



 
 
Thread Tools Display Modes
  #1  
Old January 12th, 2006, 12:51 PM posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:13 AM.


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