hi harmeet
you dint get my question.. for your type of solution i've to get everything in
rows viz. against each date ive to get 10 names then the date changes..
i do not want to remove names from column headings..
please see the file.. that is the original file.. if you could please form a
pivot in that only and mail me the same.. i shall be very grateful..
ankur lodha
Date: Tue, 31 Mar 2009 14:33:27 +0530
Subject: $$Excel-Macros$$ Re: pivot table help
From: harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
CC: ankurlod...@hotmail.com
Mate,
see attached file.
That is self explanatory
On Tue, Mar 31, 2009 at 12:12 AM, ankur lodha <ankurlod...@hotmail.com> wrote:
hi everyone
i've a task to prepare an attendance register of 10 candidates at my office..
i'm stuck in pivot table formation.. I'm attaching the sheet for your perusal..
I want name of candidates in rows.. present / leave / comp off / holiday being
the column header and count of presents / leaves .. etc. pertaining to each in
data field..
eg:
present leave holiday comp off
names count of each
Please help..
ankur lodha
So many new options, so little time. Windows Live Messenger.
--
Thanks & Regards,
Harmeet Singh
_________________________________________________________________
The new Windows Live Messenger. You don’t want to miss this.
http://www.microsoft.com/india/windows/windowslive/messenger.aspx
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
