Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-08-2017, 09:13 AM
dave57 dave57 is offline Returning text, date, time, location from one Excel sheet to another Windows 7 64bit Returning text, date, time, location from one Excel sheet to another Office 2010 64bit
Novice
Returning text, date, time, location from one Excel sheet to another
 
Join Date: Jun 2017
Posts: 9
dave57 is on a distinguished road
Default Returning text, date, time, location from one Excel sheet to another

Good Morning,


I am working with a workbook that has two sheets. One titled Quals and the other titled ATMS. It is one I use to track the qualifications of the 73 people in my department. I am trying to have Excel return the course description, the date/time of the training and the location.
On the Quals sheet, I have the employees names listed in Col "G". The info I want is contained on the ATMS sheet in columns "H", "I", "M", "N". I am trying to get Excel to give me the info, if it is there, in the corresponding row for a particular employee on the Quals sheet.
The ATMS sheet is constantly changing as new quals are obtained or lost so I have to be able to search the entire sheet and if it finds the employee's name in column "B", AND the Event Start (column "M") has at date/time entry(MM/DD/YYYY HR:MIN) then Excel will report the info in column "H"(ID, text), column "I"(TITLE), column "M"(EVENT START) AND column "N"(BLDG/FL/RM) info into column "O" on the "Quals" sheet.
Reply With Quote
 

Tags
multple sheet, search column



Similar Threads
Thread Thread Starter Forum Replies Last Post
OneNote on Android phone View Tags? Enter Date, Time, Date & Time DrTwinkyEsq OneNote 0 03-27-2017 07:54 PM
Returning text, date, time, location from one Excel sheet to another Expiry Date Excel sheet! Emperor Excel Programming 6 10-27-2015 11:50 PM
Returning text, date, time, location from one Excel sheet to another Excel 2013 – need help extracting date and time from text cell plus more. Art Mann Excel 1 07-18-2014 09:55 PM
How do you get the DATE and TIME fields to be included in an export to Excel? tpieples Outlook 0 02-18-2013 12:11 PM
Anyway to determine time/date of text creation? pureride Word 1 01-05-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:04 PM.


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