Hello all,
Not sure how to phrase my question so unsure what formula or direction to head.
Short: Excel 2010 Consolidate information from one worksheet to another.
Long: I'm looking to create an order form. I have a list of items with multiple locations. If Loc 1 requests a specific item I want that item listed on its own spread sheet separate from Location 2 and 3.
Thanks for any assistance and or recommendations.
Bookmarks