Consolidate datas

[Karthikeyan Devan]

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I would like to Consolidate different files in summary Workbook. The files are in the path C:\Time tracker and the summary workbook is in the path C:\consolidate tracker.<o></o>
<o> </o>
Here are couple of things which I need in this automation.<o></o>
<o> </o>
1). There are 5 files, namely A.xls, b.xls, C.Xls, D.xls and E.xls.<o></o>
<o> </o>
2). From all the files it has to copy from the Row # 62 till the end and delete the columns B, E, F, H, I, J, K, L.<o></o>
<o> </o>
3). After deleting all the rows, a new row needs to be inserted before of all the columns(i.e. the newly inserted column should be column “A”).<o></o>
<o> </o>
4). All the files have different ticket #. Whenever a file is getting consolidate the name of the file should appear in the A column. (i.e. if the A.xls file is gettin<o> g consolidated then in the column A, it should appear A for all he ticket #'s). this to track who has done how many tickets.</o>
<o></o>
5). These all should happen in sheet 3 of the summary workbook.

Any help on this would be really really appreciated

 

[Karthikeyan Devan]

Any help on this would be greatly appreciated