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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.