Automatically data Update from sheet1 to sheet2

Hello Venkat and FDibbins,

I am attaching the sample file. could you please enter the data in sheet1 and it should be directly updated into sheet2 with the same name or same column. As example on attached sheet we have a phonecalls column in sheet1 and it directly updated the same phonecalls column name in sheet2 like wise I need all columns should be updated in attached sheet.

Thank you,
K.Mukesh

Hi Mukesh,

The Sheet1 doesnt have any matching column in sheet2..
Example..

IF sheet1 have Coumn "NAME" then on the basis of Name in sheet 1 & name in Sheet2 & if they match then only the other data as Phone Number, CAll Duration etc should be updated in Sheet2???

Or what.. i am

Hi Mukesh,

IF we add The names Column in Sheet1 then Both the sheets will have same/Common Columns
So my question is, IF Sheet1 & Sheet2 are same then What will macro benefit here.. we can just put a refrence of Sheet1 to Sheet2 thats it..
Correct me if i am wrong...

Please Parth007 help me with tha example. Could you please keep the refernce and send me the Book6 excel sheet.

Hi Mukesh,

Please find the attached Excel..

You enter data in source sheet & once you are done press the Command Button "UPDATE"
all the data will be copied to the Data sheet next to it...

Mukesh First fill the data in Sheet1 & then press update button, the data from sheet1 will be copied to sheet2

Once you open the file you need to enable the conetents, macro should be enabled..

I am able to do it here..

Please check this file

Helo Else copy the below code as written

Copy this code in VBA editor Source Sheet

Please Login or Register  to view this content.

Copy this code in Module Editor

Please Login or Register  to view this content.