Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prompted data entry
I need to prompt the user for data entry as follows:
user will enter data to the following cells: F24, F25, F26 and F27. cell F24 includes a drop down list that users can pick the data. Sometimes users enter data to F25, F26 and F27 without entering the data in F24 (it is left as blank). How can I prompt users to enter data to F24 when they enter data in F25, F26 and F27? In other words, F24 cannot be left blank if there are data in F25, F26 and F27. Please help!! Regards Jill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the VBA to put the password in the prompted box | Excel Discussion (Misc queries) | |||
Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions |