Excel 2007 : issue copying sheet w/ names in calculations

[BobbyD1120]

I have created a "budgeting" sheet that Im using to track my personal monthly budget. I have many names cell such as DatePd, DateDue, AmoutPaid etc for each bill payer. These names are used in my calculations as well as used in my conditional formatting.

The issue Im having is that when I select the sheet and move/copy the sheet it copies the sheet and names but it doesnt appear to update them in the sheet. Therefore if currently have a Jan 2011 sheet, I want to copy this MINUS any values to a Feb 2011 sheet. When I copy it I want the names to take those of the Feb 2011 sheet to use in the calculations and conditional formatting.

How can I accomplish this? Im hope I made sense in what Im trying to accomplish :-)

[MarvinP]

Hi BobbyD1120 and welcome to the forum.

How about saving your current sheet with all the named ranges in it to a different name. Then go in and remove all the numbers. Will that be just as good?

Some people create a workbook with just formulas and named ranges and stuff in it with no data. Each time they want a new month, they simple copy this (no values) template to a new workbook name (like Feb 2011) and start filling in the numbers from there on the new name copy.

[BobbyD1120]

Thanks for the reply. Id prefer to keep it in the same workbook so i can refer back to the previous months as needed. I like to have a single workbook for the entire year.

[MarvinP]

Hi BobbyD

I think you missed the point. I must have not made it strong enough. If you save the workbook (with all the named ranges in it) and then rename the workbook, you will have the named ranges available. If you copy the worksheets to another workbook, the named ranges don't follow.

I hope this makes my previous suggestion more sensible.