Main Sheet

From: Ranjith Kurian <RanjithKurian@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 28 May 2009 22:13:01 -0700

Hi,

I have more than two sheets and the first sheet is named as Main and the
other sheets are named as per employee names, everyday each person update
there work assigned status to the respective sheets, i need a macro to
consolidate the total count of PC column and AU column as per todays date to
main sheet as examples shown below

sheet Main:
EMP Date PC AU

sheet X:
Date PC AU
27-05-09
28-05-09 completed audit
29-05-09 completed audit
29-05-09

sheet Y:
Date PC AU
27-05-09
28-05-09 completed audit
29-05-09 completed audit
29-05-09 completed

Answer required is as below, i need the count of x and y sheets only todays
details, every day when i open main sheet it should show me only todays
information (yesterday data need to be replaced by today everday)

EMP Date PC AU
X 29-05-09 1 1
Y 29-05-09 2 1

.

Follow-Ups:
- RE: Main Sheet
  - From: Joel

Prev by Date: Re: Looping Help Please
Next by Date: Application.Quit Not Working in Office 2007
Previous by thread: Check for duplicate numbers from ones entered and anoter set
Next by thread: RE: Main Sheet
Index(es):
- Date
- Thread

Relevant Pages

Re: Selecting Date
... Easy enough to add code to "if cell is blank put in today's date else leave ... not want it to alter the saved date to todays date. ... an XLS sheet I want it to allow me to change the date but not automatically ... That code would go into the appropriate sheet module. ...
(microsoft.public.excel.misc)
Re: Selecting Date
... not want it to alter the saved date to todays date. ... an XLS sheet I want it to allow me to change the date but not automatically ... get my if statement to work (I tried to get something like " if cell is blank ... That code would go into the appropriate sheet module. ...
(microsoft.public.excel.misc)
Re: Selecting Date
... not want it to alter the saved date to todays date. ... an XLS sheet I want it to allow me to change the date but not automatically ... get my if statement to work (I tried to get something like " if cell is blank ... That code would go into the appropriate sheet module. ...
(microsoft.public.excel.misc)
Re: Getting error using Month()
... Mainworksheet is a Worksheet variable that was defined the sheet name ... I dont think that is the problem. ... Cell B19 is defined as date and it contains todays date on the format ... In my Vba code I am trying to verify if todays month is different than ...
(microsoft.public.excel.programming)
Re: Letters to a graph or formula?
... >Frank Kabel ... >> mentioned earlier, on one sheet, and then I have to go ... >> ENTER it on another for this feature you just helped me ...
(microsoft.public.excel.worksheet.functions)