Hi experts,

I wish I would have this trick/script from you!

I have one excel file (ex: CPU_MEMORY_Usage.xls) which stores CPU and Memory data. And I have several data excel files which contains cpu and memory data.

As an example of data excel file is DB1.nmon.xls. In this file there are several worksheet I need to copy data from worksheet1: colum A, B, C. And Row upto 300. And then paste it to CPU_MEMORY_Usage.xls in a worksheet1.

In the same way I have to copy data from worksheet4 from DB1.nmon.xls and paste it to CPU_MEMORY_Usage.xls in a worksheet4.

I require to continue this process for several data excel files. Could you guys help me to automate this process??

Please please help. Everyday i am tiried of doing this big process manually.