+ Reply to Thread
Results 1 to 2 of 2

Showing whole items with only selected ingredients sheet

  1. #1
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Kuwait
    MS-Off Ver
    Excel 2013
    Posts
    115

    Showing whole items with only selected ingredients sheet

    Hello All,
    This one is little tricky, at least for me.


    This sheet represent the item name like 111,222 and so on and so forth
    Col A below 1092,1449, so on and so forth, shows the ingredients used in making this product
    Col B Shows the name of ingredients and that remains same from the ingredients sheets

    Process We use vlookup to get the ingredients in final recipe sheet and cost the product

    Query There are items which contain highly consumed ingredients like 1092, 1093 and so on and so forth

    I need a formula or VBA or reporting method, where those items which contains the ingredients like 1092,1093, those items will be shown and with respective formulas and remaining items will be deleted

    Output is shown in output sheet.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Kuwait
    MS-Off Ver
    Excel 2013
    Posts
    115

    Re: Showing whole items with only selected ingredients sheet

    Hello All,
    No reply to this so far...
    Kindly assist..

    AT

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Trying to copy selected items from sheet to listbox then selected back to sheet
    By BigWes1960 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-14-2013, 03:27 PM
  2. Showing/hidding particular rows for selected items on a dropdown list
    By Aim in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-03-2012, 06:43 AM
  3. Replies: 2
    Last Post: 06-02-2009, 12:27 PM
  4. Showing/Hiding Only Selected Items in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-28-2007, 06:31 AM
  5. Replies: 1
    Last Post: 06-24-2005, 12:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1