update data from one excel to another excel file

V

venu

Hallo All,

I have two excel files one is Main_data.xls and second one is
Secondary_data.xls having some of the columns from Main_data.xls

when every I add or change some data in Main_data.xls it should also change
in Secondary_data.xls file.

I have different columns in Main_data.xls in columns A, C, E when ever there
is a change in data it should also be updated in the columns A, B, C of
Secondary.xls file.

kindly help me regarding this.

I am attaching the sample files.

Regards,
Venu.
 
R

Ragdyer

Open both WBs.

Select the first column (A) of Main,
Right click in the selection and choose "Copy".
Navigate to the Secondary WB, and right click in the cell where you wish to
start the data duplication.
Choose "Paste Special", and then click on "Paste Link".

You have now created a linked range, where any changes to the Main WB will
be reflected in the Secondary WB.

Now, just do the same thing for the other columns.
 
Top