+ Reply to Thread
Results 1 to 4 of 4

Drop Down Lists pulling from other sheets

  1. 02-07-2018, 02:54 PM #1
    nikwak
    nikwak is offline
    Registered User
    Join Date
    08-06-2008
    Location
    East Ayrshire
    MS-Off Ver
    2308
    Posts
    37

    Drop Down Lists pulling from other sheets

    I have a workbook with 10 sheets. One 9 of those sheets I have charts that update themselves from formulas on those sheets. I have taken a data range for each chart and defined a name for them individually (eg: Newcastle, Canterbury, Belfast, etc). On the 10th sheet I have made a drop-down list with all the names of the charts on them so that my client can choose from the list and the appropriate chart will appear on that sheet.

    What I have achieved so far is choosing a cell (on sheet 10), copying it, pasting it to where I want to place the chart, Paste Special using Link to Picture. When I change the formula in the formula bar to say =Canterbury, then I get the Canterbury chart showing - so all is well so far. Now I just need the list to to become active so I can choose it from there rather than having to type this in the formula bar.

    Hope that makes sense and hope I've put this on the correct thread

    Nick
    Reply With QuoteRegister To Reply
  2. 02-07-2018, 06:01 PM #2
    ben_hensel
    ben_hensel is offline
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Drop Down Lists pulling from other sheets

    Off-hand I suspect that the Past Special: Link to Picture is not an automatable step.

    How different are the charts? If they're the same layout etc with different data by site, why not just put a helper table in Worksheet 10 that populates with data from the other tabs depending, and then build the chart off of that?

    If that's no good then I'd really need to see an example spreadsheet to dig into this.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
    Reply With QuoteRegister To Reply
  3. 02-08-2018, 07:35 AM #3
    nikwak
    nikwak is offline
    Registered User
    Join Date
    08-06-2008
    Location
    East Ayrshire
    MS-Off Ver
    2308
    Posts
    37

    Re: Drop Down Lists pulling from other sheets

    Thank you for the reply. The charts are all the same size - here is a link to the file on OneDrive if that is any help: (removed)

    At the moment I only have 2 x charts in the name range - didn't want to do them all until I got it working. The two in the name range are Newcastle and Canterbury
    Last edited by nikwak; 02-09-2018 at 12:37 PM.
    Reply With QuoteRegister To Reply
  4. 02-09-2018, 12:37 PM #4
    nikwak
    nikwak is offline
    Registered User
    Join Date
    08-06-2008
    Location
    East Ayrshire
    MS-Off Ver
    2308
    Posts
    37

    Re: Drop Down Lists pulling from other sheets

    Just to say I have figured it out. Using helper cell to reference each chart by name and insert it in proper place
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Connected Drop lists in different sheets
    By felipemedlev in forum Excel General
    Replies: 2
    Last Post: 04-02-2016, 01:23 PM
  2. [SOLVED] Pulling information from 2 drop down lists on separate tabs
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-14-2013, 10:20 PM
  3. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  4. Drop down lists cross sheets with more than one column.
    By jxales in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-24-2013, 01:52 PM
  5. Drop Down Lists and Hyperlinks to other Sheets
    By smohs14 in forum Excel General
    Replies: 3
    Last Post: 02-25-2012, 08:22 AM
  6. Pulling data from matrixes on other sheets using a drop down menu
    By chrisben337 in forum Excel General
    Replies: 2
    Last Post: 12-23-2010, 09:30 PM
  7. drop down lists referencing tables creating other drop down lists!!
    By Stumped- in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-07-2009, 11:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1