+ Reply to Thread
Results 1 to 3 of 3

Bringing over rows of data based on drop down selection in different sheet

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    Victoria, Australia
    MS-Off Ver
    2010
    Posts
    1

    Bringing over rows of data based on drop down selection in different sheet

    Hello, I have a spreadsheet with multiple sheets. On one page are the registration details for an event and on that page there is a column which asks if a voucher is required - options are Required or Not Required. On the second sheet I would like to fill the rows with the information of the rows in sheet one (name, phone number etc) where "Required" is selected and not bring over the info of the rows in sheet one where "Not Required" is selected.
    I have been trying to get this to work for a week and to no avail.
    If I haven't supplied enough info please let me know and I will try to respond with as much detail as possible.
    Thanks in advance

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Bringing over rows of data based on drop down selection in different sheet

    Without an Excel sheet, seeing how and where your data are laid out - this is almost impossible. Please attach a sample worksheet showing the problem and the desired results.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Bringing over rows of data based on drop down selection in different sheet

    See if you can adapt this:

    Lookup with multiple instances of the lookup value

    In your case the lookup value would be cells that contain "Required".
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. 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
  2. [SOLVED] Copy from different sheets- data based on selection and paste rows in new sheet
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-17-2014, 03:30 AM
  3. Transferring data based on drop down selection to another sheet on the same workbork
    By misswendyloo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2013, 12:44 PM
  4. [SOLVED] Looking for an easy way to change data on a sheet based on drop-down selection
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 09:39 AM
  5. How to unhide rows based on drop down box selection?
    By jgomez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2012, 05:55 PM

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