Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation,........how to use a list in another sheet
Hi my name is susy,
I wanted to know how can I make use of a list thats in another sheet (sheet3) to validate a cell(in sheet 1). I'm trying to make a drop down list with some options but if ome one else does work in this sheetthey should not be able to delete it. That's why I though of paste the list into another sheet and Hide the sheet which contains the list. But it sems like I can validate a cell with a list in another sheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation,........how to use a list in another sheet
Name the source range in sheet3 and use this name as source in your
validation list! Regards, Stefi €žsusy€ť ezt Ă*rta: Hi my name is susy, I wanted to know how can I make use of a list thats in another sheet (sheet3) to validate a cell(in sheet 1). I'm trying to make a drop down list with some options but if ome one else does work in this sheetthey should not be able to delete it. That's why I though of paste the list into another sheet and Hide the sheet which contains the list. But it sems like I can validate a cell with a list in another sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
List Validation Based on another sheet | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
combo box from data validation with source list in separate sheet | Excel Worksheet Functions | |||
How to save an Exel-sheet with over 10,000 list-/validation-field. | Excel Discussion (Misc queries) |