Hi frnds..
I want to prepare a excel sheet in which i want to enter some records. There are two sheets one for data entry ( named 'source') and other containing all the data entered ( named 'master') . Now what i want is as soon i enter data in source sheet and press enter or some other trigger, the data should automatically get added to master file and field for data entry in source sheet becomes blank so that next data can be entered.
I want to prepare a excel sheet in which i want to enter some records. There are two sheets one for data entry ( named 'source') and other containing all the data entered ( named 'master') . Now what i want is as soon i enter data in source sheet and press enter or some other trigger, the data should automatically get added to master file and field for data entry in source sheet becomes blank so that next data can be entered.