How to copy a sheet from another workbook

[dflak]

The question “How do I copy a page from one workbook to another” comes up just about daily.

Attached is a “generic” spreadsheet that can be used in three ways:

1. You can make a copy of this workbook and “build” your report around it.

2. You can copy the code into an existing workbook. In the Initialize Variables section of the code, there are a lot of assignments that look up the various variables from the named ranges on the control panel sheet. Replace these statements with hard-coded paths and names.

3. You can look at the code to see how things are done and write your own VBA from the example.