| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column must be filled before going another column.
Hi..
Can i know how should i go with; in a way that users have to enter data for column1 first before go to other column2. If user forget to enter for column1, it will prompt the users. thanks~ |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column must be filled before going another column.
See "Tools- Validation"
*** Please do rate *** "kyoshirou" wrote: Hi.. Can i know how should i go with; in a way that users have to enter data for column1 first before go to other column2. If user forget to enter for column1, it will prompt the users. thanks~ |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column must be filled before going another column.
Data Validation is triggered by an incorrect entry, not by no entry at all so
this method cannot possibly work for user. Rating.......low Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 03:13:02 -0700, Naveen wrote: See "Tools- Validation" *** Please do rate *** "kyoshirou" wrote: Hi.. Can i know how should i go with; in a way that users have to enter data for column1 first before go to other column2. If user forget to enter for column1, it will prompt the users. thanks~ |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column must be filled before going another column.
From a Dave Peterson posting..............
I'd use a nice visible cell and format it in big bold red letters. Say your range you want to check is 3 cells (a1:A3). Then in B1: =if(counta(a1:a3)=3,"","You must enter all three cells") Actually, I like to use an adjacent cell for each cell that must be filled in. =if(a1="","","<-- This cell cannot be left blank!") End Dave P........................................ Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 02:26:02 -0700, kyoshirou wrote: Hi.. Can i know how should i go with; in a way that users have to enter data for column1 first before go to other column2. If user forget to enter for column1, it will prompt the users. thanks~ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column must be filled before going another column.
And Validation is under Data not Tools.
Lower yet. Gord On Thu, 24 Aug 2006 09:03:54 -0700, Gord Dibben <gorddibbATshawDOTca wrote: Data Validation is triggered by an incorrect entry, not by no entry at all so this method cannot possibly work for user. Rating.......low Gord Dibben MS Excel MVP On Thu, 24 Aug 2006 03:13:02 -0700, Naveen wrote: See "Tools- Validation" *** Please do rate *** "kyoshirou" wrote: Hi.. Can i know how should i go with; in a way that users have to enter data for column1 first before go to other column2. If user forget to enter for column1, it will prompt the users. thanks~ Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
