Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-13-2017, 01:25 PM
FUGMAN FUGMAN is offline Comparing between 2 worksheets and retreiving data if a match Windows 10 Comparing between 2 worksheets and retreiving data if a match Office 2016
Banned
Comparing between 2 worksheets and retreiving data if a match
 
Join Date: Feb 2017
Posts: 55
FUGMAN is on a distinguished road
Default Comparing between 2 worksheets and retreiving data if a match

I created “data input"worksheet which only contains the data for one record. After data is entered, it will be relocated to another worksheet labeled "location". I would like to compare the data in range E1:G1 (containing first name, mid initial, and last name) on my “data input" worksheet” against the data contained in columns E, F, and G of a multi-row worksheet, labeled "List". If any row of the multi-row worksheet "List" has an identical match in its Columns E, F and G, I would like to import all the remaining data in that row (columns H thru Z) into “the data input sheet”. All the worksheets involved are in the same workbook. Thanking all in advance for any assistance regarding this.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Index Match Function across different worksheets shay_mt Excel 2 04-27-2015 06:04 AM
Comparing between 2 worksheets and retreiving data if a match comparing data sjp1966 Excel 6 07-23-2014 11:43 AM
Comparing two excel worksheets SaneMan Excel 1 06-27-2012 07:52 PM
Comparing Data - MS Excel ramadevidokkuud Excel 1 05-19-2011 05:52 AM
Comparing between 2 worksheets and retreiving data if a match Comparing Data leroytrolley Excel 1 08-09-2008 08:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:30 AM.


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