PDA

View Full Version : copy data



oleg_v
07-05-2010, 11:52 PM
hi
i have a question:is it possible with a macro to copy data from one workbook to another to specified sheet and range?


thanks

Aussiebear
07-05-2010, 11:57 PM
Absolutely

oleg_v
07-06-2010, 12:01 AM
thanks

if it so can i ask for some help?

i have i file "mp000586.xls" on desktop and i need to copy from this file from sheet1 range "A1:A50" to the file "cpk.xls" on disk c: to sheet2 range "B2:B52"


thanks

Bob Phillips
07-06-2010, 12:05 AM
Do it in Excel with the macro recorder on, that will generate the necessary code.