URGENT HELP NEEDED COPYING EXCEL SHEET FROM ONE BOOK TO ANOTHER

[JrClown]

I need help in copying one Excel worksheet from book1 to book2

"The reward of one duty done is the power to fulfill another"
<%
Jr_Clown@Yahoo.com
%>
​

 

[ilses]

If you have a specific problem, please provide a little more information.

In general, to copy say Sheet1 to Book2 you can use something like

Workbooks("Book1.xls").Sheets("Sheet1").Copy _
        Before:=Workbooks("Book2.xls").Sheets(1)

The VBA help gives some info and examples about variations on this theme.

Best regards,

ilses

 

[ilses]

Yes, but do add

Sub NameOfYourMacro()
'code
End Sub

and put it in a module associated with the correct workbook.

To quickly get the hang of it, start the macro recorder and record the steps in Excel that you wish to automate. The reorded code will have a lot of superfluous gibberish in it, but gives helpful clues about objects, methods etc.

HTH

ilses