Apr 12 2022 07:13 PM - edited Apr 12 2022 07:32 PM
Question:
If a particular value in Productivity report sheet is 0, macro has to check if they took leave for 8 hrs on that particular day in the leave tracker sheet. If yes those 0s should be replaced with L.
If they weren't on leave, macro should check if their total downtime in NPT sheet pivot sums up to 8 hrs on that particular day. If its so, those 0s should be replaced with T.
Kindly note that, the values in productivity sheet will be obtained using vlookup formulas unlike this reference file.
Please help me with this!