software

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.Open both WBs.

Select the first column (A) of Main,
Right click in the selection and choose quot;Copyquot;.
Navigate to the Secondary WB, and right click in the cell where you wish to
start the data duplication.
Choose quot;Paste Specialquot;, and then click on quot;Paste Linkquot;.

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.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
quot;venuquot; gt; wrote in message
...
gt; Hallo All,
gt;
gt; I have two excel files one is Main_data.xls and second one is
gt; Secondary_data.xls having some of the columns from Main_data.xls
gt;
gt; when every I add or change some data in Main_data.xls it should also
change
gt; in Secondary_data.xls file.
gt;
gt; I have different columns in Main_data.xls in columns A, C, E when ever
there
gt; is a change in data it should also be updated in the columns A, B, C of
gt; Secondary.xls file.
gt;
gt; kindly help me regarding this.
gt;
gt; I am attaching the sample files.
gt;
gt; Regards,
gt; Venu.
gt;