How can I copy data from one excel to another excel automatically?

[sandeepsharma]

Hi,
I have a daily job to copy some data from excel1 to excel2. Is it possible to copy the data automatically using some script or tool?
please suggest.

 

[onlyadrafter]

Hello,

try using the macro recorder, this will record a program for you to use again. If you then have any problems, please post back with a clearer description of your requirements.

 

[sandeepsharma]

Will Macro help me to copy records between two separate sheets? Ok, I will make it more clear. I have 2 excels, Excel A and Excel B, Suppose I want to copy data from 1st row of Excel A to 3rd row of Excel B, is it possible to do it through macro?
Please suggest.

 

[onlyadrafter]

Hello,

like I said earlier, use the marco recorder to record the progam, then post back with any problems you may have.

 

[sandeepsharma]

Thanks a lot buddy....i was not aware that macros can run between separate sheets....thank you...