Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation issue Excel 97

Status
Not open for further replies.

scrappe7

Technical User
Jul 30, 2001
82
US
Hello, I am using excel and I have a spreadsheet that has only 1 column where data should be entered. The problem is that a user should not be able to enter data in row 2 of that column without data first being entered in row 1 of that column. The data will be text and probbaly not numeric, if that matters. It is very important that the user be restricted to enter data in the columns in a sequential manner only. I don't want to have to use any VBA because I'll mess it up. Any help is greatly appreciated, thanks.

-Needy in NY
 
Without VBA ??? Heresay!! LOL

Have you tried Data/Validation from the menu ?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top