03-06-2013, 10:13 PM
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
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