Bring Data from other worksheets....

  • Thread starter Thread starter Krefty
  • Start date Start date
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
 
There are 2 points I do not quite understand from your post:-

1) 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
Click to expand...

2) How can I use the same formula to
 
Back
Top