LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cityfc
 
Posts: n/a
Default SORTING DATA TO ANOTHER 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 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
Sorting Identical Data set in a work sheet SAT Excel Worksheet Functions 0 September 13th 05 10:46 PM
data from one sheet to several in sequential order! firecord New Users to Excel 6 June 22nd 05 05:10 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Append the data given in diff sheets of an Excel File to one sheet sansk_23 Excel Worksheet Functions 3 May 10th 05 02:00 AM
Multiple worksheet queries liam Excel Worksheet Functions 3 February 16th 05 06:52 PM


All times are GMT +1. The time now is 03:03 PM.

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

About Us

"It's about Microsoft Excel"