+ Reply to Thread
Results 1 to 4 of 4

Drop down Menu across multiple sheets

  1. #1
    Registered User
    Join Date
    11-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Drop down Menu across multiple sheets

    Good-day

    I am working on a menu list which is on sheet 1 (Meals price List) columns A5 to A8.
    I also have sheet 2 (Item price List) which is the list of ingredients that go into a recipe. Then I have Sheets 3, 4, 5 and 6. (The different recipes (Worksheet names) as indicated below:-
    1. Beef curry
    2. Broad beans Curry
    3. Cabbage Curry
    4. Corned meat Curry
    I am trying to use the drop down function in sheet 1(Meals Price List) for Columns A5 to A38, these need to be the heading of each recipe e.g. Beef Curry, in other words I want to choose which Recipe (Sheets 3,4,5 and 6) I want from the list.

    Then I need to do a lookup of each recipe on the dropdown to tie into each meal total found on each recipe (B34) this should be displayed under price per meal heading Sheet in sheet 1(Meals Price List) columns B5 to B8 for each meal or recipe.
    Attached Files Attached Files

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Drop down Menu across multiple sheets

    B5 drag down:
    =INDIRECT("'"&A5&"'!B34")
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Drop down Menu across multiple sheets

    Hi and welcome to the forum

    Waar omtrent in SA? SA ex-pat living in USA here

    take a look at the attached and see if that is what you want? I added a new sheet (sheetnames) where I pull in all the sheet names (menu items), and then use this for the DV on the Proce List.

    Then I used INDIRECT() to pull in the cost from each sheet

    mmmm been years since I had a beef curry, had bunnie chow a few years back in Durbs though
    Last edited by FDibbins; 11-23-2013 at 06:34 PM.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    11-18-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Drop down Menu across multiple sheets

    Thanks to both of you for your valued comments.

    Fdibbins .....Ek is van Durban af....the town where Bunnies started. Trust you having a great time in the US.

    I am grateful for the tips you have given me and I am very new to this form, but for the life of me where did you attach this document? Lol.

    Thanks

+ 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. Drop down menu across multiple sheets
    By Pragasen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-19-2013, 10:58 AM
  2. How to use drop down menu to populate data to other sheets
    By andy.k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2013, 08:59 PM
  3. Drop down menu to populate multiple sheets
    By jerrett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-12-2012, 09:01 AM
  4. Drop Down Menu list for multiple sheets
    By iamreese in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-02-2012, 11:10 AM
  5. Excel 2007 : Hide Sheets using drop-down menu selection
    By SgtGrayMatter in forum Excel General
    Replies: 2
    Last Post: 03-18-2010, 01:29 PM

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