K
Krefty
Good Evening and thank you for looking at my problem....
I have a workbook that is a schedule for a staff of 5.
Each worksheet is a month in the year Oct, Nov etc., then
at the end of this workbook I have a worksheet named Whole
Year. I want to see each respective month on the whole
year by referancing each already filled cell on the
various months. Unfortunatly when I auto sum a specific
cell on any of the multiple months I populates with a 0
instead of "D" or "N" as indicated on the schedules. On
the individual pages I use =IF (X7="",X6,X7) to allow me
to enter any vacation, sickness, etc. Keeping the
individual month as original showing both changes and
original schedule. How can I use the same formula to
populate with the ACTUAL D, N or PTO that is indicated on
the Month worksheet.
Thanks in Advance for looking....
Krefty
I have a workbook that is a schedule for a staff of 5.
Each worksheet is a month in the year Oct, Nov etc., then
at the end of this workbook I have a worksheet named Whole
Year. I want to see each respective month on the whole
year by referancing each already filled cell on the
various months. Unfortunatly when I auto sum a specific
cell on any of the multiple months I populates with a 0
instead of "D" or "N" as indicated on the schedules. On
the individual pages I use =IF (X7="",X6,X7) to allow me
to enter any vacation, sickness, etc. Keeping the
individual month as original showing both changes and
original schedule. How can I use the same formula to
populate with the ACTUAL D, N or PTO that is indicated on
the Month worksheet.
Thanks in Advance for looking....
Krefty