Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul

Copper Contributor

Dear Gentlemen,

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.

awaiting your response....

Ref. attached file
Regards,
aligahk06

1 Reply

Sir,

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.