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.
|