B
BigCarol
I HAVE A WORKBOOK THAT HAS DROP DOWNS WITH INDIVIDUAL LETTERS THAT STAND FOR
DIFFERENT REASONS FOR ABSENTEEISM. I WANT TO ADD AN ADDTITIONAL SHEET TO THE
WORKBOOK THAT WILL SUM FOR EACH CALAENDAR DAY THE AMOUNT OF FOR EXAMPLE V'S
(STANDS FOR VACATION) THAT ARE SCHEDULED FOR THAT DAY INPARTICULAR.
HERE IS THE BASIC SET UP OF THE WORKBOOK
*THERE ARE 29 SHEETS WITH EACH SHEET REPRESENTING AN EMPLOYEE
*WITHIN THE SHEET CONTAINS EVERYMONTH BY DATE
*EACH DAY (CALENDAR DATE) HAS A CELL THAT WILL BE POPULATED WITH
A LETTER THAT STANDS FOR AN ABSENCE REASON
*I WANT TO MAKE A REPLICA SHEE THAT ON EACH CALENDAR DAY, WILL SUM UP
THE AMOUNT OF V'S ETC THAT ARE LISTED THAT DAY BY ALL OF MY EMPLOYEES.
THE EXTRA SHEET ONLY NEEDS TO BE ABLE TO SUM UP THE AMOUNT OF V'S BECAUSE I
WILL BE NAMING THIS SHEET 'VACATION' I WILL THEN MAKE A COUPLE OTHER SHEETS
THAT CAN CALCULATE THE OTHER REASONS FOR ABSENCES.
ONE LAST THING, MY CALENDAR DATE CELLS HAVE DROP DOWNS IN THEM, THIS IS WHAT
IS TOTALLY CONFUSING ME.
PLEASE HELP!!!!
DIFFERENT REASONS FOR ABSENTEEISM. I WANT TO ADD AN ADDTITIONAL SHEET TO THE
WORKBOOK THAT WILL SUM FOR EACH CALAENDAR DAY THE AMOUNT OF FOR EXAMPLE V'S
(STANDS FOR VACATION) THAT ARE SCHEDULED FOR THAT DAY INPARTICULAR.
HERE IS THE BASIC SET UP OF THE WORKBOOK
*THERE ARE 29 SHEETS WITH EACH SHEET REPRESENTING AN EMPLOYEE
*WITHIN THE SHEET CONTAINS EVERYMONTH BY DATE
*EACH DAY (CALENDAR DATE) HAS A CELL THAT WILL BE POPULATED WITH
A LETTER THAT STANDS FOR AN ABSENCE REASON
*I WANT TO MAKE A REPLICA SHEE THAT ON EACH CALENDAR DAY, WILL SUM UP
THE AMOUNT OF V'S ETC THAT ARE LISTED THAT DAY BY ALL OF MY EMPLOYEES.
THE EXTRA SHEET ONLY NEEDS TO BE ABLE TO SUM UP THE AMOUNT OF V'S BECAUSE I
WILL BE NAMING THIS SHEET 'VACATION' I WILL THEN MAKE A COUPLE OTHER SHEETS
THAT CAN CALCULATE THE OTHER REASONS FOR ABSENCES.
ONE LAST THING, MY CALENDAR DATE CELLS HAVE DROP DOWNS IN THEM, THIS IS WHAT
IS TOTALLY CONFUSING ME.
PLEASE HELP!!!!