HarvCLAUtilities
Electrical
- Apr 24, 2008
- 5
NKT's answer works well, but it only works in the same sheet. I would like to create the list or lists on one sheet (Hidden) and use it throughout the workbook. Is this possible? thanks in advance
NKT (Structural) 11 Apr 08 16:22
Data --> Validation ... opens a "Data Validation" dialog box
on the "Settings" tab:
Allow --> List
Source --> (select cells with your desired input value list)
Then highlight the cell and drag with the right mouse button to select your column of input cells, and select "fill formatting only". This will copy the data validation (pull down menus) to your column of input cells.
NKT (Structural) 11 Apr 08 16:22
Data --> Validation ... opens a "Data Validation" dialog box
on the "Settings" tab:
Allow --> List
Source --> (select cells with your desired input value list)
Then highlight the cell and drag with the right mouse button to select your column of input cells, and select "fill formatting only". This will copy the data validation (pull down menus) to your column of input cells.