+ Reply to Thread
Results 1 to 2 of 2

Copying a range of cells based on the selection of a drop down choice in another sheet

  1. #1
    Registered User
    Join Date
    03-25-2018
    Location
    South Lyon, Michigan
    MS-Off Ver
    2010
    Posts
    11

    Copying a range of cells based on the selection of a drop down choice in another sheet

    I have seen this question listed with similar sheets but I cannot get it to work for my workbook.

    So this project just became slightly more complex. Same thought process, Chassis 1 Common Cause tab is the main input source. The Chassis 1 Top Ten will be selectable based on the selection of the user. All info should flow over with the drop down choice. I have attached the actual spreadsheet I am using instead of a template.

    Complete workbook attached.

    Jason
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Copying a range of cells based on the selection of a drop down choice in another sheet

    Maybe try:

    In Cell C3:
    =IFERROR(INDEX('Chassis 1 Common Cause'!C$3:C$122,MATCH($B3,'Chassis 1 Common Cause'!$B$3:$B$122,0)),"")
    You can copy this over to column H and then down.

    In Cell J3: (It's the same formula, but it's not in a merged cell)
    =IFERROR(INDEX('Chassis 1 Common Cause'!J$3:J$122,MATCH($B3,'Chassis 1 Common Cause'!$B$3:$B$122,0)),"")

    In Cell J4:
    =IFERROR(INDEX('Chassis 1 Common Cause'!J$4:J$123,MATCH($B3,'Chassis 1 Common Cause'!$B$3:$B$122,0)),"")

    You can copy these formulas across.

    then with both rows selected (J3:Y4), you can drag (or copy) down.

+ 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. Replies: 4
    Last Post: 06-28-2022, 03:51 AM
  2. Copy paste range of cells based on drop down list selection
    By jrx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2016, 10:23 AM
  3. Replies: 0
    Last Post: 05-27-2015, 06:06 AM
  4. Copying data to another sheet based upon YES/NO drop-down selection
    By Tsonga in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2014, 09:05 AM
  5. [SOLVED] sumif referencing a range based on a choice from a drop down
    By jv5875 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2014, 06:45 PM
  6. Replies: 3
    Last Post: 10-31-2013, 04:23 PM
  7. Copy cell range from another sheet based on drop down selection.
    By nhen.enry in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 08-09-2012, 09:24 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