Hi
Hoping someone can help me
I have a workbook that consists of two tabs. I have From a "calendar" that records employee absence through Sickness (S) or Industrial Sickness (I)
We are finally going into the modern ages and will be recording this in a T&A system in the future. However, I need to prepare a file (in the format of Tab: Example, so the historical absence can be imported into the new system.
My file is below.
Tab: For Completion: Is the calendar currently in use
Tab: Example: Is what info I need to output (the unit will always be day)
https://drive.google.com/open?id=1ohGrU7erwJ3SDCnYeHCtfn0uBe_S1FFd
Any help would be greatly appreciated.
JMAW
Hoping someone can help me

I have a workbook that consists of two tabs. I have From a "calendar" that records employee absence through Sickness (S) or Industrial Sickness (I)
We are finally going into the modern ages and will be recording this in a T&A system in the future. However, I need to prepare a file (in the format of Tab: Example, so the historical absence can be imported into the new system.
My file is below.
Tab: For Completion: Is the calendar currently in use
Tab: Example: Is what info I need to output (the unit will always be day)
https://drive.google.com/open?id=1ohGrU7erwJ3SDCnYeHCtfn0uBe_S1FFd
Any help would be greatly appreciated.
JMAW