Home

Data Validation to multiple sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-1098861%22%20slang%3D%22en-US%22%3EData%20Validation%20to%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098861%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20link%20or%20use%20data%20validation%20from%20one%20sheet%20to%20another%20using%20the%20same%20contents%20from%20a%20specific%20sheet%20where%20validation%20was%20setup%3F%20I%20prefer%20not%20to%20hide%20a%20column%20on%20each%20sheet%20to%20use%20data%20validation%20as%20I%20don't%20want%20others%20to%20alter%20the%20contents%20and%20I%20prefer%20not%20to%20lock%20the%20sheet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1098861%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1099061%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Validation%20to%20multiple%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1099061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F511942%22%20target%3D%22_blank%22%3E%40D_Haberman%3C%2FA%3E%20I%20tend%20to%20use%20a%20dedicated%20worksheet%20with%20a%20table%20for%20each%20DV%20list.%20To%20make%20sure%20the%20DV%20list%20works%20on%20every%20version%20of%20Excel%2C%20I%20assign%20a%20range%20name%20to%20the%20body%20of%20each%20table%20and%20use%20the%20range%20name%20in%20the%20DV%20list.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Can you link or use data validation from one sheet to another using the same contents from a specific sheet where validation was setup? I prefer not to hide a column on each sheet to use data validation as I don't want others to alter the contents and I prefer not to lock the sheet. 

1 Reply
Highlighted

@D_Haberman I tend to use a dedicated worksheet with a table for each DV list. To make sure the DV list works on every version of Excel, I assign a range name to the body of each table and use the range name in the DV list. See attached.