My workbook starts with the month of July and, after entering July data, I copy that worksheet to a new sheet tab in the same workbook and name the new tab August. I enter the data for August and copy that worksheet to a new sheet named September. Each monthly worksheet has six different print views. How can I have the six custom views that I set up for the July sheet copied with each new monthly sheet and refer to the new sheet and not to the original July sheet. Any way to refer to the current sheet name?
Using Excel 2003.
Thanks
Don Scott
Using Excel 2003.
Thanks
Don Scott