PDA

View Full Version : Workbook -macros query



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.

Bob Phillips
02-26-2014, 07:51 AM
Workbooks("MASTER.xlsx").Worksheets("AB").Range("A1:K300").Copy
Workbooks("DEST.Xlsx").Worksheets("AB").Range("A1")