+ Reply to Thread
Results 1 to 5 of 5

Return multiple non-adjacent cells based on drop down list

  1. #1
    Registered User
    Join Date
    11-13-2014
    Location
    Windsor, VA
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Return multiple non-adjacent cells based on drop down list

    Good afternoon,

    I am having trouble with what seems to be a relatively easy task. My goal is to create a production report summary that takes data from multiple non-adjacent cells and returns them in a summary page. I would like to use a drop down list for days of the week to "autopopulate" the summary area. I realize that I can do this with multiple nested IF statements but was looking for something a little less cumbersome. I have some familiarity with VBA but haven't used it in about a year...

    In the attached workbook, the summary sheet takes data from 'PASTE Day' and 'PASTE Night'. It focuses on the Line/Actual value (I.E. cell G6 on sheet Tri-fold relates to cell E5 on sheet PASTE Day). I would like all of the information in column G, H, and I on Tri-fold to update based upon the list in I2.

    Thanks in advance for any help!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Return multiple non-adjacent cells based on drop down list

    Here's a template for a summary sheet that I use. Perhaps it'd be of some assistance with your situation.
    Attached Files Attached Files

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Return multiple non-adjacent cells based on drop down list

    Due to the way the data is organized, I inserted a row 4 on both the Day and Night worksheets and inserted the days of the week to match up with the columns where the values are located.

    There were odd spaces in the data in column which caused problems. Using Find and replace, I eliminated the offending spaces.

    I added a column (hidden) to take the PL number and add Actual to it so that the value could be matched on the Day ad Night worksheets.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  4. #4
    Registered User
    Join Date
    11-13-2014
    Location
    Windsor, VA
    MS-Off Ver
    MS Office 2010
    Posts
    2

    Re: Return multiple non-adjacent cells based on drop down list

    Thanks to both! I will be using newdoverman's solution for my application but I like the dropdown lookup template as well (just doesn't fit this application as nicely as I would like).

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Return multiple non-adjacent cells based on drop down list

    Thanks for the feedback.

+ 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 List to return multiple results in multiple cells
    By Joshua27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2014, 11:50 AM
  2. Replies: 1
    Last Post: 04-12-2013, 06:27 PM
  3. [SOLVED] Create a Drop down list with dates based on adjacent Cell
    By smugglersblues in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-15-2013, 02:39 PM
  4. [SOLVED] How Can I return an adjacent value based on the choice of my drop down list?
    By William_IV in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-04-2012, 03:25 PM
  5. Replies: 3
    Last Post: 07-06-2010, 05:30 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