Gingertrees
08-17-2009, 10:04 AM
Hello,
Background: I maintain a workbook used by around 30 people in which they place their client's info on the Cases sheet and the several other sheets all reference the Cases sheet. (Via a drop-down ID at the top of each sheet called a URN.) Each user has 1 copy of the workbook.
The other sheets need so many updates, I think it would be faster to just give all my users a new copy of the workbook, and do a "move or copy sheet" for their existing Cases sheet into the new workbook. This creates a few problems: named cells/ranges have to be fixed and added again (doable), and the Data Val on the URN on the other sheets get messed up (not doable). Problem is, I can't seem to fix this latter problem. Even removing Data Validation altogether, redefining the named range, and redoing it, it errors.:dunno
Help?
More hints:
--> the URN drop down references the 1st column of Cases in a named range called NAMES
--> most other data in the other sheets uses VLOOKUP referencing all the data on Cases in a named range called CLIENTS
Background: I maintain a workbook used by around 30 people in which they place their client's info on the Cases sheet and the several other sheets all reference the Cases sheet. (Via a drop-down ID at the top of each sheet called a URN.) Each user has 1 copy of the workbook.
The other sheets need so many updates, I think it would be faster to just give all my users a new copy of the workbook, and do a "move or copy sheet" for their existing Cases sheet into the new workbook. This creates a few problems: named cells/ranges have to be fixed and added again (doable), and the Data Val on the URN on the other sheets get messed up (not doable). Problem is, I can't seem to fix this latter problem. Even removing Data Validation altogether, redefining the named range, and redoing it, it errors.:dunno
Help?
More hints:
--> the URN drop down references the 1st column of Cases in a named range called NAMES
--> most other data in the other sheets uses VLOOKUP referencing all the data on Cases in a named range called CLIENTS