clear, copy and paste
 

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.

clear, copy and paste
 

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.

clear, copy and paste
 

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.


.

clear, copy and paste
 

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

--
Regards,
Tom Ogilvy

"Richard Leclezio" wrote in message
...
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.


.

clear, copy and paste
 

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

"Richard Leclezio" wrote in message
...
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.


.