Forum Members,

1 - I am not a programmer.

2 - I have a Microsoft Excel 2000 workbook with 30 worksheets within it. In location "A8" in each worksheet I manually type the last day of the month. For example: "October 31, 2009".

3 - Is there a way to place a variable in location "A8" in each worksheet so that I need only manually type "October 31, 2009" only once in the workbook? If there is a simply way; please be specific and detailed in your solution.

4 - When I need to work on the next month's activity; "November 30, 2009", I will make a copy of the previous month's workbook and change the text from "October 31, 2009" to "November 30, 2009".

5 - Thank you for your attention to this request.