Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-18-2014, 07:08 AM
timomaha timomaha is offline matching data from one work sheet to another, then auto filling missing cell information Windows 7 32bit matching data from one work sheet to another, then auto filling missing cell information Office 2010 32bit
Novice
matching data from one work sheet to another, then auto filling missing cell information
 
Join Date: Jul 2014
Posts: 2
timomaha is on a distinguished road
Default matching data from one work sheet to another, then auto filling missing cell information


I have two worksheets with similar data in one work book. I need data from one worksheet auto filled or transferred to another by specific names. On one worksheet I have a list of houses(column1) and corresponding addresses(column2). I have houses called bluehouse1 and bluehouse2 in column 1 listed multiple times with corresponding addresses of 1234 and 1235 in column 2. On the other worksheet I have a list of house names but no addresses. I need to use the first worksheet to get addresses listed in the second worksheet but cannot figure out a formula to complete this and doing it one at a time takes too long. Please help. Any suggestions? I attached a workbook that is similar to what I need.
Attached Files
File Type: xlsx Microsoft forum example.xlsx (10.6 KB, 10 views)
Reply With Quote
  #2  
Old 09-12-2014, 07:51 AM
AngelaSWard AngelaSWard is offline matching data from one work sheet to another, then auto filling missing cell information Windows 8 matching data from one work sheet to another, then auto filling missing cell information Office 2010 64bit
Novice
 
Join Date: May 2014
Location: Fresno, CA
Posts: 11
AngelaSWard is on a distinguished road
Default

You could try a Vlookup.
Reply With Quote
Reply

Tags
auto fill, cell references, matching

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
matching data from one work sheet to another, then auto filling missing cell information Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Data not showing from Access linked work sheet shabbaranks Excel 0 01-08-2014 02:52 AM
Auto populate invoice (including description) from data sheet agenevieve Excel 2 12-06-2012 04:48 AM
Filling the consecutive cell by day. aligahk06 Excel 1 09-15-2010 08:17 AM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.


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