Hi all
I have a table useres need to enter data to.
One line is one event. So for each new event they will have to start a new line.
Since the table is endlessly long and people might not realize that they are "opening" the new event in a row way down on the sheet, and not below the previous event I'd like to prevent this.
The first four columns are hidden and contain data for VLookups. The first field to be entered is in in column E. And the first row containing data is row 10 (above that there's a lot of blabla)
Scenario: Rows 10 to 35 are filled with data.
Next event would be entered in row 36. But if a user enters the data in row 72 (not realizing this) a whole lot of lines will stay empty. And if someone is looking for this event he might not find it instantly. (Additonal propblem: If the following event would be entered in rwo 36 the "history" would be inconsitent).
--> So, basicly I am looking for a VBA Code which would chek whether the cell above the first empty cell in column C (after row 10) and if so, return a message box (e.g. "Please enter values in first empty row")
Any chance of doing this?
Thx
FD
Bookmarks