Hi there
I have received 15 respondent sheets (all with same structure) who evaluated a part number according to 4 different criteria. Hence, I have Respondent 1 who gave a score for a part number for criterion 1, criterion 2, criterion 3 and criterion 4. I now want to program a VBA that allows me to automatically populate one "merged all" sheet; showing each respondent's score per criterion per part number--> see attachment
Thanks for your help!!
Hi.
You haven't given us any indication of what your expected results should look like. can you do so (on your sheet). that way, we can see what you want, rather than guessing.
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
For Crit1 In D10 thiscopy right to end crit1 and down
=IFERROR(INDEX(INDIRECT("'"&D$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&D$9&"'!$A:$A"),0),10),"")
For Crit2 in U10For Crit3 in AL10=IFERROR(INDEX(INDIRECT("'"&U$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&U$9&"'!$A:$A"),0),14),"")For Crit4 in BC10=IFERROR(INDEX(INDIRECT("'"&AL$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&AL$9&"'!$A:$A"),0),18),"")maybe you have to change the red numbers (columnnumbers)=IFERROR(INDEX(INDIRECT("'"&BC$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&BC$9&"'!$A:$A"),0),22),"")
Kind regards
Leo
Last edited by LeoTaxi; 11-01-2016 at 05:19 AM.
For Crit1 In D10 thiscopy right to end crit1 and down=IFERROR(INDEX(INDIRECT("'"&D$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&D$9&"'!$A:$A"),0),10),"")
For Crit2 in U10For Crit3 in AL10=IFERROR(INDEX(INDIRECT("'"&U$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&U$9&"'!$A:$A"),0),14),"")For Crit4 in BC10=IFERROR(INDEX(INDIRECT("'"&AL$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&AL$9&"'!$A:$A"),0),18),"")maybe you have to change the red numbers (columnnumbers)=IFERROR(INDEX(INDIRECT("'"&BC$9&"'!$A:$Z"),MATCH($A10,INDIRECT("'"&BC$9&"'!$A:$A"),0),22),"")
Kind regards
Leo
Last edited by LeoTaxi; 11-01-2016 at 05:05 AM.
Great, this is exactly it, many thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks