how to copy data from one excel sheet to another automatically?

[sandeepsharma]

Hi,
I want to transfer some data from one excel to another on daily basis. Is it possible to automate this process? by using any macro or some kind of script?
I have to transfer the data between 2 excels.
Please help
Thanks

[Richard Buttrey]

Hi,

Yes, it's a common task. Does the worksheet you want to copy from always have the same name? In which case you can hard code the name in the macro, otherwise you'll either need to prompt the user for a name or read the name from a cell in the workbook into which you want to copy data

The general format of such a macro, assuming the workbook name is fixes is:

Please Login or Register  to view this content.

[ExlGuru]

You can do it very easily by using VBA. The changing filename is not an issue if both sheets are in the same file, so I guess thay are not. That being so, if you can put the active VBA code into the source file, and refer to self as ThisWorkbook, actual filename does not then matter. If you want to 'grab' (rather than send) it is a little trickier. Working on the first assumption for now, copy this to a code module:

Please Login or Register  to view this content.

Try this hope this helps.
Good Luck