Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Multiple Places Changing
I have some Data Validation I have used on a template worksheet that then
gets repeated over and over in a workbook. Different users then fill out the worksheets. I want to change the input message that appears for the Data Validation screen for all the workshhets at the same time rather than one at a time. Group editing the worksheets does not allow me to do this. Is there any way to do this??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Multiple Places Changing
You could change the data validation input message on one sheet.
Then, copy the changed cell Select all the worksheets Select the cells where you want the revised validation Choose EditPaste Special, select Validation, click OK Lee wrote: I have some Data Validation I have used on a template worksheet that then gets repeated over and over in a workbook. Different users then fill out the worksheets. I want to change the input message that appears for the Data Validation screen for all the workshhets at the same time rather than one at a time. Group editing the worksheets does not allow me to do this. Is there any way to do this??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Multiple Options | Excel Discussion (Misc queries) | |||
data validation | Excel Worksheet Functions | |||
Changing Where Data Validation List Boxes Open in Mac Excel 2004 | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
data validation - select multiple options? | Excel Discussion (Misc queries) |