MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Validation List, using a different worksheet for source?

Posted by Tamara on November 15, 2001 6:58 AM

Has anyone figured out a good way to "trick" excel so that you can set up a validation list on a seperate worksheet? I can't put the data on main worksheet, as the user needs to save it as .csv so it can be imported into another program. The import routine wouldn't know what to do with the extra data, yet the import will fail if certain data doesn't match the values it is expecting.

any hints would be appreciated!



Posted by Paul Akkermans on November 15, 2001 7:07 AM

Give the range a name (Insert->Name->Define). This name can be used in the validation list.

Posted by Tamara on November 15, 2001 7:25 AM

Paul - thanks for the hint! Worked like a charm!! :)