As I read the forums, I see that the question, "How do I copy a sheet from one workbook to another?" is asked almost daily.
I've come up with a generic workbook that could be used in two ways:
1. You could make a copy of it, and build your workbook around it by adding sheets and formulas, etc. and hide the Control Panel sheet when you are done with it.
2. You could copy the code into an existing workbook and in the initialize variables section, "hard code" the items that are currently looked up from static named ranges on the Control Panel Sheet.
Is there some place where it would be appropriate to post this workbook (along with the yet-to-be-written instructions).
I'd post the workbook here for reference, but there's no advanced button.
Bookmarks