jignesh142
11-17-2012, 10:34 AM
I have some data in one excel file and i want to open the another excel file, copy the data in that excel file and then close it again. In short i want to export that data in another excel file.
Also i want to transpose the data in following manner, for example
Old excel range A1-D1 to new excel Range A1-A4
Old excel range A2-D2 to new excel range A5-A8
Old excel range A3-D3 to new excel range A9-A10
And so on.....
Can any body help me ?
Also i want to transpose the data in following manner, for example
Old excel range A1-D1 to new excel Range A1-A4
Old excel range A2-D2 to new excel range A5-A8
Old excel range A3-D3 to new excel range A9-A10
And so on.....
Can any body help me ?