have already tried to record, but an error meeasge comes
up when i Columns("A:G").Select
-----Original Message-----
select the default sheet cells button(left of the A and
above the
1)copyselect the cells button on the monarch sheetpaste
if you want a macro, try the recorder.

"Richard Leclezio"
wrote in message
...
I have a workbook with a sheet "default" that has data
in
it. I then have a workbook with a sheet "monarch" that
also has data in it. What i need done is the data
in "monarch" cleared and then the data from "default"
copied and paste in "monarch". Please help.


.