Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-842148%22%20slang%3D%22en-US%22%3EPulling%20data%20from%20MenaData%20and%20BioData%20in%20result%20sheet%20based%20on%20employee%20id%20and%20then%20result%20in%20resul%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842148%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EDear%20Gentlemen%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20three%20excel%20sheet%20in%20an%20excel%20workbook.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E1.%20I%20want%20to%20pull%20data%20from%20menaData%20sheet%20from%2016-8-19%20to%2015-9-19%20based%20on%20employee%20id%20put%20on%20result%20sheet%20B4.%20i.e%20for%20e.g%20i%20put%20employee%20id%2024576.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2.%20I%20want%20to%20pull%20data%20fromBioData%20sheet%20from%2016-8-19%20to%2015-9-19%20based%20on%20employee%20id%20put%20on%20result%20sheet%20B5.%20i.e%20for%20e.g%20i%20put%20employee%20id%2024576.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3.%20In%20Result%20sheet%20i%20want%20to%20verify%20for%20employee%20id%2024576%20either%20it%20is%20true%20or%20false%20in%20cell%20range%20menaData%20C4%3AAG4%20and%20bioData%20cell%20range%20C5%3AAG5%2C%20the%20result%20in%20result%20sheet%20c6%2C%20d6%20and%20so%20on%20till%2015-9-19%20or%20available%20data.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eawaiting%20your%20response....%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ERef.%20attached%20file%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ERegards%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3Ealigahk06%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842171%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20data%20from%20MenaData%20and%20BioData%20in%20result%20sheet%20based%20on%20employee%20id%20and%20then%20result%20in%20r%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842171%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3ESir%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EPullimg%20data%20coulmn%20value%20for%20menaData%20is%20B4%20%2C%20C4%20AND%20SO%20ON%20UNTIL%20AF4%20for%20employee%20id%2024576%20from%20menaData%20like%20retuen%20data%20dayoff%20%2C%2008%3A00%3A00%20AM%20TO%2004%3A00%3A00%20PM%20and%20so%20on%20.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EPullimg%20data%20coulmn%20value%20for%20bioData%20is%20B5%20%2C%20C5%20AND%20SO%20ON%20UNTIL%20AF5%20for%20employee%20id%2024576.%20from%20BioData%20return%20column%20value%20timetable%20Range%20E%3AE%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThen%20match%20in%20result%20sheet%20true%20or%20false%20based%20on%20above%20two%20column%20data%20one%20by%20one%20in%20corresponding%20cell.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Abdul H Khan
Occasional 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. 

Related Conversations