Create a Template of a Worksheet to Copy

Hey guys,

So right now I have a worksheet where you input a code and the cell next to it has a numeric value appear (based on the code). The way I have it structured is that another worksheet references the code, and then I do all the dirty work calculations in that worksheet, and my original sheet with the code references the dirty work sheet in the cell location of where the numberic value will be. So basically I have a worksheet for neat and clean display and another for doing dirty calculations.

I have added a macro button to create a new sheet, however I am running into some issues. I copied the initial clean sheet with no information on it and have it labeled as a template. The problem is that this template references that dirty worksheet. So I figured I would copy an empty dirty worksheet as well. How do I get it so these "template worksheets reference each other with out manually doing it and how do I get it so each time I hit the new sheet button, it copies these templates but has it so the new copies reference each other and not the template worksheets?

Thanks!

andrew c.,

Instead of using two different sheets, you could put the calculations in the display worksheet, way off to the right or below and then just hide the rows or columns so they can't be seen.

~tigeravatar