| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input data from one worksheet to another
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index Indirect to input worksheet name and range name | Excel Discussion (Misc queries) | |||
| Rename a Worksheet on Input of Value in Cell | Excel Worksheet Functions | |||
| How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
| Input to populate report worksheet | Excel Worksheet Functions | |||
| Budget input form/worksheet | New Users to Excel | |||
Linear Mode
