+ Reply to Thread
Results 1 to 2 of 2

How to copy a table from one sheet to another based on dropdown selection

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    dubai
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to copy a table from one sheet to another based on dropdown selection

    Hi

    please help me in achieving the following:
    I have 2 sheets in one workbook, the first sheet named D1 where I have dropdown menus and the second sheet called reference where I have fixed data

    what im looking for is when the user select an option from the dropdown menu on cell b3 on "D1" sheet based on the selection an entire table (4 rows by 3 columns) called "Default" from reference sheet to be automatically pasted into the D1 sheet

    thanks in advance
    novel
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-21-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: How to copy a table from one sheet to another based on dropdown selection

    you can go to data validation>> under settings >> validation criteria>> click on allow list with Source =Default;
    Formula on C3=VLOOKUP(B3,Default,3,FALSE)

+ 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: 2
    Last Post: 10-07-2013, 11:06 AM
  2. Modify formulas on the entire sheet based on dropdown selection
    By robolist in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-06-2013, 07:22 AM
  3. Replies: 8
    Last Post: 02-10-2013, 01:15 PM
  4. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  5. Copy cells based on dropdown selection
    By wcnwzrd in forum Excel General
    Replies: 1
    Last Post: 10-16-2009, 01:48 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