mikelmike
02-26-2014, 05:16 AM
HI,
Im new to the world of macros/VBA...Pls help me to write a macro to copy a data from one workbook to another work book.
1.workbook1 name as MASTER.xlsx, workbook 2 as DEST.Xlsx
2. in Master tab "AB" is having a data from Range (A1:K300),copy this data and paste it on DEST.xlsx tab "AB"
3.both workbooks will be open and active before run the macro.
4.macro code will be written on another excel/workbook name "MACRO1" with one button,when it clicks the macro should run.
Pls help.
Im new to the world of macros/VBA...Pls help me to write a macro to copy a data from one workbook to another work book.
1.workbook1 name as MASTER.xlsx, workbook 2 as DEST.Xlsx
2. in Master tab "AB" is having a data from Range (A1:K300),copy this data and paste it on DEST.xlsx tab "AB"
3.both workbooks will be open and active before run the macro.
4.macro code will be written on another excel/workbook name "MACRO1" with one button,when it clicks the macro should run.
Pls help.