clear, copy and paste

[Richard Leclezio]

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.

 

[Don Guillett]

select the default sheet cells button(left of the A and above the
1)>copy>select the cells button on the monarch sheet>paste
if you want a macro, try the recorder.

 

[Richard Leclezio]

have already tried to record, but an error meeasge comes
up when i Columns("A:G").Select

 

[Tom Ogilvy]

worksheets("Monarch").Cells.Clear
worksheets("Default").Cells.Copy
Destination:=Worksheets("Monarch").Range("A1")

 

[Don Guillett]

Sub copysht()
Sheets("sheet1").Cells.Copy Sheets("sheet3").Cells
End Sub