Help......

  • Thread starter Thread starter kiran
  • Start date Start date
K

kiran

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
 
Back
Top