Topazpower
Board Regular
- Joined
- Mar 2, 2009
- Messages
- 63
I Need a Macro which Copies and paste the contents from "Master.xls' to another workbook named "Backup.xls"
Master .xls is feeded with datas every now and then.
The cells that are to be copied are: a1 - j1 from "Master.xls" to "Backup .xls" which is in the following root E:/Backup/Backup.xls.
If data is feeded in b2 - j2 of "Master.xls", then the same should also be copied, down under a1-j1 of "Backup.xls". So "Backup.xls" should keep updated when new datas are feeded in "MASTER.XLS"
Can it be done if the "Backup.xls" is a closed workbook.
Please help.
Regards
Jane.
Master .xls is feeded with datas every now and then.
The cells that are to be copied are: a1 - j1 from "Master.xls" to "Backup .xls" which is in the following root E:/Backup/Backup.xls.
If data is feeded in b2 - j2 of "Master.xls", then the same should also be copied, down under a1-j1 of "Backup.xls". So "Backup.xls" should keep updated when new datas are feeded in "MASTER.XLS"
Can it be done if the "Backup.xls" is a closed workbook.
Please help.
Regards
Jane.