Jan 09 2020 06:03 AM
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.
Jan 09 2020 07:12 AM
@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.