#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default Display in a new tab

Hi all,
I've an excel sheet that i use to track the attendance of my employees,the
sheet looks like this:
C D E F
G
7/01/2007 7/02/2007 7/03/2007 7/04/2007 7/05/2007
8 Peter attend annual sick P.sick
attend
9 John attend attend sick P.sick
E
10 John attend annual E Absent
E

Now i want to display in another tabs the following:
* The dates that were taken as : annual ,E ,Absent ,Sick,P.sick or study
leave.
Is there a way to do this?


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
How to display remaining txt file which overflowed MsgBox display? EagleOne Excel Discussion (Misc queries) 1 November 2nd 06 01:10 PM
Display every 3rd category name but still display latest month maryj Charts and Charting in Excel 1 September 24th 06 09:05 PM
Can I display an Excel chart as my screensaver display? Burke Charts and Charting in Excel 0 August 1st 06 07:01 PM
how to display numbers in thousands i.e display 10,000 as 10 excel2002 Excel Worksheet Functions 4 April 26th 06 07:53 PM
Numbers display as decimal, i.e. enter 123 display 1.23 IGH219 Setting up and Configuration of Excel 1 June 16th 05 09:16 PM


All times are GMT +1. The time now is 01:36 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"