lookup and paste issue with loop

Hi Experts...
i am facing hard to lookup array and need your help....description is below and data you can find in attached workbook

As Is Scenario

If user input “X” in relationship table in “relation” tab, and click on “cmd1” then the “prcode” of “aaa3” (D5) will be insert into same row of “aaa1” (A8) in the “load” tab under column AV.

To Be Scenario

• If user input “X” in multiple column but same row in “relation” tab…then values should be comma separated in load tab (column AV)

• If user input “X” in multiple rows and multiple columns in “relation” tab…then values should be send to relevant cell in load tab (column AV)


current code

Please Login or Register  to view this content.