Hi I am a newbie in Macro, I have a file that has two sheets, Sheet1 contains images while Sheet 2 contains data (productid, product description..) I want to use macro wherein, when I click an image in Sheet 1, for example I will click the image located in A2, a certain row in Sheet2 will be automatically copied to A3 of Sheet1.

And also, I want an option (like inserting a button that will hide the details that have been copied to A3).


Please help! Thank you!