+ Reply to Thread
Results 1 to 8 of 8

if the correct answer is given copy question to different sheet

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    if the correct answer is given copy question to different sheet

    all,


    i have a questionaire that has yes/no answers basically i want some way of copying the question over to a different sheet if it answered yes so that on sheet 3 i will only have questions that were answered yes



    kind regards


    ricky

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: if the correct answer is given copy question to different sheet

    Which are the columns that you use? In which column exist the YES, text?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: if the correct answer is given copy question to different sheet

    hi,


    my column will be H that will contain the Yes/NO answers and i want them to paste the questions to sheet3 column A


    thnk you

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: if the correct answer is given copy question to different sheet

    ARRAY formula. Copy down and across.

    =INDEX(Sheet1!G$2:G$20,SMALL(IF(Sheet1!$H$2:$H$20="yes",ROW(Sheet1!G$2:G$20)-1),ROW(Sheet1!G1)))


    -- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
    Not just Enter.
    Last edited by Fotis1991; 09-09-2013 at 09:48 AM.

  5. #5
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: if the correct answer is given copy question to different sheet

    Hi,

    im sorry to be a pain.

    My questions are in sheet one column A my answers are in sheet1 column H and based upon column H's yes answers i want the questions from column A copied to sheet3

    hope this clears it up if you need any more info please let me know

    thank you again!

    ricky

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: if the correct answer is given copy question to different sheet

    Just change the column in INDEX part of the formula.

    =INDEX(Sheet1!a$2:a$20,SMALL(IF(Sheet1!$H$2:$H$20="yes",ROW(Sheet1!a$2:a$20)-1),ROW(Sheet1!a1)))

  7. #7
    Registered User
    Join Date
    03-30-2012
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: if the correct answer is given copy question to different sheet

    worked well thank you

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: if the correct answer is given copy question to different sheet

    You are welcome.

    Feedback is always appreciated from the people that spend time trying to help you!


    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

+ 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. correct answer to a thread
    By martindwilson in forum The Water Cooler
    Replies: 25
    Last Post: 08-02-2013, 08:26 AM
  2. [SOLVED] How to add points when the answer is correct?
    By jkskates in forum Excel General
    Replies: 3
    Last Post: 10-31-2012, 09:21 PM
  3. Replies: 1
    Last Post: 10-18-2012, 06:35 AM
  4. Need macro to copy data from sheet 1 to multiple pages on sheet 2 in correct cells
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-16-2009, 03:33 PM
  5. Copy entire row from one sheet to another base on answer
    By nhatrang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2008, 01:30 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