+ Reply to Thread
Results 1 to 3 of 3

combo box linking to data

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    64

    combo box linking to data

    Hi, new to this forum.

    wondering if someone could help by showing me an example to help me create a model.

    the goal is to use the summary sheet and determine which subsiduary i want to view in a specific currency & then be able to compare to a number of differnent data such as previous year, years prior, budget, forecasts etc.

    ive used combo box to create the dropdown menu's with lists.

    ive created a very simple p&l & data worksheet.

    question is how do i link the data to the dropdown lists and then how to automatcially update my p&l.

    just need an example of it and i should be able to figure out the rest as in real life the p&l's are very long and tricky.

    many thanks
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-23-2014
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    64

    Re: combo box linking to data

    Sorry know i shouldn't bump but if anyone can help id really appreciate it

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,840

    Re: combo box linking to data

    You should put some comments (textboxes) in the affected sheets to explain what you want to do and what the result should be.
    Ben Van Johnson

+ 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. Help linking data to a dropdown/combo box
    By Chamberienne in forum Excel General
    Replies: 0
    Last Post: 04-18-2013, 08:40 AM
  2. Input data in next row/ linking combo box in user form.
    By DECROMAX in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2013, 04:32 AM
  3. linking data from a combo box to another sheet
    By curly88 in forum Excel General
    Replies: 1
    Last Post: 09-25-2006, 07:25 PM
  4. [SOLVED] Linking a combo box
    By J.D. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2006, 02:55 PM
  5. [SOLVED] Combo Box Linking
    By mully in forum Excel General
    Replies: 0
    Last Post: 12-01-2005, 11:15 AM

Tags for this Thread

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