Compulsory cell input
- Thread starter Bryz
- Start date
NARAYANK991
Excel Ninja
Hi ,
It is easier if you force users to enter data into columns B and C before they can input data in column A ; this can be done using Data Validation ; when a user tries to enter data in column A , Excel can check whether data has already been entered in columns B and C ; if so , the data entered in column A will be accepted , else the user will see an error message informing them that data needs to be entered in columns B and C before it can be entered in column A.
Narayan
It is easier if you force users to enter data into columns B and C before they can input data in column A ; this can be done using Data Validation ; when a user tries to enter data in column A , Excel can check whether data has already been entered in columns B and C ; if so , the data entered in column A will be accepted , else the user will see an error message informing them that data needs to be entered in columns B and C before it can be entered in column A.
Narayan
SirJB7
Excel Rōnin
Hi, Bryz!
As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/
Regards!
As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/
Regards!
Hi,
Thank you for the quick response! Unfortunately that's not quite what I need...
The spreadsheet is a central repository for metrics and the issue is that people input the name, but then don't input the description and/or other details, making their entry effectively useless for other users. Which is why I'm hoping it's possible to make input to the following columns compulsory.
Again thanks for the help!
Bryz
Thank you for the quick response! Unfortunately that's not quite what I need...
The spreadsheet is a central repository for metrics and the issue is that people input the name, but then don't input the description and/or other details, making their entry effectively useless for other users. Which is why I'm hoping it's possible to make input to the following columns compulsory.
Again thanks for the help!
Bryz
NARAYANK991
Excel Ninja
Hi Bryz ,
In that case , data entry can be done using a form , which accepts data entry , validates it , and then writes valid data to the worksheet. This will involve VBA ; is this acceptable ?
Narayan
In that case , data entry can be done using a form , which accepts data entry , validates it , and then writes valid data to the worksheet. This will involve VBA ; is this acceptable ?
Narayan
NARAYANK991
Excel Ninja
Hi Bryz ,
In that case , please upload your workbook , or at least a sample workbook , specifying what fields will be entered , what kind of data validation will have to be done , and into which cells in the workbook the data will need to be transferred.
Narayan
In that case , please upload your workbook , or at least a sample workbook , specifying what fields will be entered , what kind of data validation will have to be done , and into which cells in the workbook the data will need to be transferred.
Narayan