Hello,
I have a workbook where I copy a new sheet for each week of the year. The sheet is a copy of the previous. I have defined entire columns with names on the original sheet, the problem is that when I copy the sheet, the name refers back to the previous sheet, ex. 'Sheet1'!$A:$A even though I enter the name as =$A:$A. Is there any way to define this name to update to the current sheet?
Thank you,
Chris
Try this; when defining the name intitially (or go back up to Define Name and edit it) type in the sheet name along with the defined name (e.g. Sheet1!Test). When I copied the sheet then, it still came up with the box saying I already had that name in the workbook but I responded Yes and it worked. Let us know if this works for you.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
When defining the range name, prepend the sheet name to the range name.
Example:
<insert><name><define>
Names in workbook: Sheet1!MyRangeName
Refers to: =$A$10:$B$20
Does that help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks