Question: how to import data in excel from another excel file?
Answer: Click on the data menu in the ribbon. Then click on 'Get External Data' and from the sub menu select 'from other sources. From the drop down options select 'From Microsoft Query' In the 'Choose Data Source' window click on 'Excel files*' and 'OK'. Then select the file from which you wish to import the data.