Hi All,
I have 3 seperate excle(Crystal.xls, AMETITSG.xls, ITSGAsia.xls).
If any data added in Column A of Crystal.xls and any data added in column D
of AMETITSG.xls should be automatically added in Column A of ITSGAsia.xls

TIA

Kiran,

Use one workbook, with one database, with an additional column to show whether the data is Crystal
or AMEITTSG or whatever, and use data filters or custom views to show the set off data you are
interested in for each. Any other solution is a waste of time and will likely fail over time.

HTH,
Bernie
MS Excel MVP


"kiran" wrote in message
...
Hi All,
I have 3 seperate excle(Crystal.xls, AMETITSG.xls, ITSGAsia.xls).
If any data added in Column A of Crystal.xls and any data added in column D
of AMETITSG.xls should be automatically added in Column A of ITSGAsia.xls

TIA