ok, so Detail2 is the workbook that I'm copying from?, and where is the sheet
that I want to copy identified in that code....

"Bill Manville" wrote:

Open the workbook
Alt+F11 to the VB editor
Insert / Module
Paste in the code

You will need to adjust the names like "Detail2.xls" in the code, of
course.

Auto_Open will run automatically when you open the workbook.
To test it you can just use Tools / Macro / Macros / Auto_Open / Run

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup