Hi Excel Guru's

Thanks so much for all the help so far.

I need to copy an b2:I65 from one workbook to another.
The workbook with the live data will be closed.
I need it to copy into the same cells B2:i65 and write over the dat
that is already existing.

(What I am doing is displaying months of data in the smae b2:i6
cells.

So was going to have buttons across the top with months on them an
whatever month is selected then the data in the Master workbook will b
copied into the above cells in the slave workbook

--
Mikeic
-----------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...fo&userid=2246
View this thread: http://www.excelforum.com/showthread.php?threadid=38372

Backup your workbooks before trying this macro.

ok let say you want to copy from workbook x.xls which is in "c:\" and
file is not opened.

you can write a macro to copy data from x.xls to the workbook which as
macro using code below.


sub macro
dim w,n as variant
application.displayalerts=false
w=activeworkboook.name
Workbooks.Open Filename:="c:\x.xls"
n=activeworkbook.name
range("b2:i65").select
selection.copy
workbooks(w).activate
range("b2").select
activesheet.paste
workbooks(n).activate
activeworkbook.save
activeworkbook.close
workbooks(w).activate
application.displayalerts=true
end if


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=383727