Hi Friends,

i have two excel sheets Sheet1, Sheet2. Sheet1 will have data and Sheet2 has the name of the Sheet1 as hyper link. I need to Click the hyperlink and extract the data from the Sheet1 and paste it n Sheet.

I need code for the logic. please help me...