Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help / Named range help
I have written a schedule for my employees in excel, I have named some ranges
so that the names of the people working on certain days will show up on the deployment schedule automatically. The problem that I am having now is that when the week is over and I have to write a new schedule, the deployment schedule is set off the current schedule. I tried to create a second "Copy" of the schedule to replace the first one, but the named range stays with the original sheet regardless of what I change the name to. How can I make the ranges stay with the sheet name rather than the original sheet? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Array as a "named range" - formula ok in cells, but error as "named range" | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) |