Forum Discussion
Data Validation to multiple sheets
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 validat...
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.