As a follow-up to the thread 'Locking info in cells' I would like to take it
a stage further.
I have a workbook (EXCEL 2003 Pro) called'Details' with two worksheets
called 'Data Input' and 'Database'.
Information is typed into cells in 'Data Input' (E11:E37) which is then
recorded permanently in cells in 'Database' (first record in row A2 to ?2 ,
second in row A3 to ?3 etc) after finding the next blank cell in column A.
Firstly, how do I do this?
Secondly, with the codes previously given, if the data was typed into the
wrong cell, the sub was exited (If Target.Address < $A$1 Then Exit Sub). Is
there any way round this?
Thanks for any help