Copy data from 1 sheet to another

[msp2]

Hi All

I have a workbook which has two sheets; "Result" & "Q&A"

On the result sheet I have list of answers that a candidate has given to the questions (assessment). Answers are all marked as Slide1, Slide2 and so on (20 Questions) .

On the Q&A sheet I have the Slide no (column A) Question(column B) Correct Answers (Column C) {Pool of 60 questions in total}

I some how want to be able to copy the data in column A, B & C in Q&A sheet of those 20 questions only which candidate has answered.

Is there a query etc that i can run which will copy the required data from "Q&A" and paste in the relevant rows (all Slide numbers are sorted accordingly - A-Z in both sheets)

See attached file as example.

Thanks

MSP

[arlu1201]

Can you upload a sample output file showing how your data should look like?

You have not mentioned where you want your data to be copied?

[kvsrinivasamurthy]

In C1 use

Please Login or Register  to view this content.

and in D1 use

Please Login or Register  to view this content.

Then drag both downwords.