clear, copy and paste

  • Thread starter Thread starter Richard Leclezio
  • Start date Start date
R

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.
 
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.
 
have already tried to record, but an error meeasge comes
up when i Columns("A:G").Select
 
worksheets("Monarch").Cells.Clear
worksheets("Default").Cells.Copy
Destination:=Worksheets("Monarch").Range("A1")
 
Back
Top