Hi! Is it possible to validate cells in one worksheet using a drop-down list where the source data is contained in another worksheet.
At the moment, I have a workbook where I maintain the same validation source list in multiple worksheets rather than one master list (actually I do use a master list but I have lookup lists in the other worksheets.
Thanks!
At the moment, I have a workbook where I maintain the same validation source list in multiple worksheets rather than one master list (actually I do use a master list but I have lookup lists in the other worksheets.
Thanks!