R
Ranjith Kurian
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
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