I would like to thank everyone for their help. I’ve learned a great deal from this forum while working on this project.
I have two final problems
PROBLEM 2 OF 2
The OCTOBER 2012 DATA ENTRY sheet is linked to the OCTOBER 2012 MONTHLY REPORT sheet. When I copy the sheets for the following months and years it obviously keeps the link to the original OCTOBER sheet. Short of editing every subsequent sheet, is there a way to keep the sheets linked but recognize the change in the following months and years (sheet names).
Bookmarks