How to copy a sheet from another workbook

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.

I modified the above so the workbook is a little "dirty" in that it has left over bits and pieces that now do nothing from the prior version.

You will still fill in the copy from information in cells B3 & B4.

Fill in the page information in the table in columns F:L. The same rules apply for example if you leave the copy end row blank, it will find the last row in the copy from sheet. In this case, I copied from the same sheet with different parameters to different paste sheets. You can enter in as many sheets as you want.