Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-24-2014, 11:37 AM
kerkstrt kerkstrt is offline Get multiple cells in separate worksheet Windows 7 64bit Get multiple cells in separate worksheet Office 2013
Novice
Get multiple cells in separate worksheet
 
Join Date: Oct 2014
Location: Grand Rapids, MI
Posts: 1
kerkstrt is on a distinguished road
Default Get multiple cells in separate worksheet

I want to choose a item (in drop down) on wks 1 ("module") , and get 1 or multiple records in a different worksheet ("item") that matches the selection. In my example, select a choice in "family" (doors), and get all matching cells in wks called "item" that match the module "doors" and pull them onto the module worksheet. Is this possible. Example attached.
Attached Files
File Type: doc select modules.doc (159.5 KB, 7 views)
File Type: xls Fidia Machine Parts Listing.xls (33.5 KB, 8 views)
Reply With Quote
  #2  
Old 10-26-2014, 11:20 PM
macropod's Avatar
macropod macropod is offline Get multiple cells in separate worksheet Windows 7 64bit Get multiple cells in separate worksheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See, for example, the attachment at: https://www.msofficeforums.com/excel...html#post68811
Although the data there are all on the same sheet, using a different sheet is no impediment.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link cells in word doc (table) to update from 2 separate docs - can this be done? larrens Word 3 09-15-2014 11:20 PM
Multiple identities in separate Outlook instances? brucemc777 Outlook 3 07-08-2014 10:36 PM
Highlight cells with changed data on a worksheet with tracking changes jpb103 Excel Programming 1 06-03-2014 07:33 AM
Can you copy & paste cells across worksheets and preserve reference to worksheet? New Daddy Excel 2 11-27-2013 07:19 AM
Get multiple cells in separate worksheet Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 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