Automatically Copy contents from One column of One excel file to Another excel file

Hello Everyone,

I am new to Excel VBA. I have two files c:\Excel\database.xlsx and c:\Excel\Insurance.xlsx.

At the moment I am copying data of two columns from database file and pasting to insurance file. I want this process to be automated and to be saved automatically. I want those two columns be copied to insurance file automatically as soon as user enters data in that column. I want to use VBA code.

I have another question. Can anyone tell me the code to lock the written / filled cells automatically. I want excel file in a way, that it automatically lock the previous filled cell as soon as user jumps to next or another cell.

if user enters the data in one cell (regardless of location of selected cell.) and as soon as user jumps in next cell the previous cell should automatically lock.

I shall be very thankful to you.

Thanks and regards

Sarabjit

Moderator's note: Moved from "Hello..Introduce Yourself"--6StringJazzer