View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
venu
 
Posts: n/a
Default Update should be done in different excel file

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.