#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the VBA to put the password in the prompted box Frank Situmorang[_3_] Excel Discussion (Misc queries) 5 May 4th 09 12:39 PM
Control Data Entry - push entry to next cell Ofelia Excel Discussion (Misc queries) 0 July 7th 08 04:19 PM
Auto entry of data based on entry of text in another column or fie Judy Rose Excel Discussion (Misc queries) 2 May 21st 08 01:14 PM
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing [email protected] Excel Discussion (Misc queries) 0 March 20th 08 12:45 PM
Cell Entry That Locks Selected Cells From Any Data Entry. ron Excel Worksheet Functions 5 February 16th 07 09:52 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"