If I click the Vendor 1 column of cell "J13" that value goes to place in worksheet of "Ve

Hii frnds,


I am new to excel coding......



My doubt is If I click the Vendor 1 column of cell "J13" that value goes to place in worksheet of "Vendor 1" of cell "K8" dynamically for all cells

Note:What I value I need that value goes to certain palce when I was click cell


Note: If I click the Vendor 2 column of cell "K13" that value goes to place in worksheet of "Vendor 2" of cell "I8" dynamically for all cells


Note: If I click the Vendor 3 column of cell "L13" that value goes to place in worksheet of "Vendor 3" of cell "I8" dynamically for all cells

please help me........


Thanks & Regards
suresh.