ExcelBanter - Data Validation List from different sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation List from different sheet (https://www.excelbanter.com/excel-discussion-misc-queries/211542-data-validation-list-different-sheet.html)

Michelle

Data Validation List from different sheet

In Excel 2003, can I use a data-validation drop-down list that reads
its data from a different sheet?

thanks

M

Max

Data Validation List from different sheet

Use a defined range as the source for the DV. Then you can.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Michelle" wrote:
In Excel 2003, can I use a data-validation drop-down list that reads
its data from a different sheet?

All times are GMT +1. The time now is 03:03 PM.