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

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-07-2019, 12:25 AM
aligahk06 aligahk06 is offline Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul Windows XP Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul Office 2007
Advanced Beginner
Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul
 
Join Date: Aug 2009
Posts: 52
aligahk06 is on a distinguished road
Default Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul

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
Attached Files
File Type: xlsx Bio_Mena_ResultCHK.xlsx (355.1 KB, 0 views)
Reply With Quote
  #2  
Old 09-07-2019, 05:39 AM
Alansidman's Avatar
Alansidman Alansidman is offline Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul Windows 10 Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul Office 2019
Advanced Beginner
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 36
Alansidman is on a distinguished road
Default

xpost: Pulling data from MenaData and BioData in result sheet based on employee id and then result in result sheet true or false based on match | Chandoo.org Excel Forums - Become Awesome in Excel
Reply With Quote
  #3  
Old 09-07-2019, 02:23 PM
Kenneth Hobson Kenneth Hobson is online now Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul Windows 10 Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 37
Kenneth Hobson is on a distinguished road
Default

cross-posted
Pulling data from MenaData and BioData in result sheet based on employee id
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Compare and result as true or false in result sheet aligahk06 Excel 1 08-29-2019 06:44 AM
Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul One Cell that controlls spread sheet result button to change simple fomula result RAH Excel Programming 5 03-31-2018 04:52 PM
Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul How To Move Focus From VLOOKUP Result to Report Sheet swindon.expat Excel 2 04-10-2016 12:15 AM
Conditional formatting using a formula that will result in different colors based on dates 19z Excel 3 05-28-2015 11:39 AM
Perform calc in active cell then highlight based on formula result grexcelman Excel Programming 4 01-12-2015 11:00 AM


All times are GMT -7. The time now is 01:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft