Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
need help with excel object
#1
Not Solved
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


Attached Files Image(s)
           
Reply


Messages In This Thread
need help with excel object - by kundan2612@gmail.com - 03-06-2013, 10:13 PM
RE: need help with excel object - by vinod123 - 03-08-2013, 12:12 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to identify the object reference to the existing(already opened) Excel sheet yogeesh 1 9,918 09-26-2012, 07:00 PM
Last Post: krr
  Run time error - Excel object sasi1982 7 7,686 11-03-2010, 05:47 PM
Last Post: KavitaPriyaCR
  Problem while using an object description from an excel jaykisan 0 2,296 10-13-2008, 04:54 PM
Last Post: jaykisan

Forum Jump:


Users browsing this thread: 1 Guest(s)