|
|
|
|
#1
10-24-2014, 11:37 AM
|
|||
|
|||
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.
|
|
#2
10-26-2014, 11:20 PM
|
||||
|
||||
|
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]
|
|
|
|
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 |
 Cells from other worksheets apear on current worksheet
|
Equilar | Excel | 3 | 05-03-2010 01:40 AM |
Windows 7 64bit 
Office 2013
Hybrid Mode