EXCEL/Macro

New Contributor

Screenshot 2022-04-13 075935.pngScreenshot 2022-04-13 080036.pngScreenshot 2022-04-13 080113.pngQuestion:

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!

1 Reply

@nivedhamv28pls reply even if u can partially solve it