need help with excel object

[kundan2612@gmail.com]

Hi there,

I need little help with an issue.Please find the description mentioned below: (Please refer the screenshot)

1) I have a global datasheet with some values(shown in screenshot)

2) I have a local excel workbook with multiple sheets.(shown in screenshot)

3) There are 3 columns in Global datasheet i.e. Comp_Name,New_Column and Value

4) I need to search the first Comp_Name value i.e. LaunchandLogin in the local workbook i.e. I have to seach which local workbook sheet matches with Comp_Name and have to go into that sheet.

5) Once I am into that sheet I have to transpose the New_Column and Values into it. (Param1 and Yes in this case)

6) I have to keep transposing the data but when I find CRELG1 as Comp_Name...then I have to repeat steps 4 and 5.(Plz refer screenshot)

If any one can provide the code for this,I will really be very grateful.

Thanks and Regards
Kundan