Help......

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help.... 0
Help......... 1
Images are pixelated when saving to PDF 0
Mail Merge Directory Conditional Page Break 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
MS Project Center-Autolink column fields 0
Shared Link is showing empty notebook 1
Auto-Numbering in a Table in MS Word 1

Top