I have three excel sheet in an excel workbook. 1. I want to pull data from menaData sheet from 16-8-19 to 15-9-19 based on employee id put on result sheet B4. i.e for e.g i put employee id 24576. 2. I want to pull data fromBioData sheet from 16-8-19 to 15-9-19 based on employee id put on result sheet B5. i.e for e.g i put employee id 24576. 3. In Result sheet i want to verify for employee id 24576 either it is true or false in cell range menaData C4:AG4 and bioData cell range C5:AG5, the result in result sheet c6, d6 and so on till 15-9-19 or available data.
Pullimg data coulmn value for menaData is B4 , C4 AND SO ON UNTIL AF4 for employee id 24576 from menaData like retuen data dayoff , 08:00:00 AM TO 04:00:00 PM and so on . Pullimg data coulmn value for bioData is B5 , C5 AND SO ON UNTIL AF5 for employee id 24576. from BioData return column value timetable Range E:E
Then match in result sheet true or false based on above two column data one by one in corresponding cell.