Data manipulation across spreadsheets

There may come situations, you require to get the values from two or more spreadsheets and use those values in a separate spreadsheet.

This can be easily done in MS Excel. Assume that there are three spreadsheets A.xls, B.xls, and C.xls. Each spreadsheet has their own sheet as A_sheet1, B_sheet1 and C_sheet1 respectively.

Now we are to create new spreadsheet ABC.xls that would use the values from cell 'C16' of sheets A_sheet1, B_sheet1 and C_sheet1. To access the cell 'C16' from each spreadsheet, use the following formula in the spreadsheet ABC.xls.

1. To access the values from cell 'C16' of sheet A_sheet1 of A.xls:
• ='D:\[A.xls]A_sheet1'!C16
2. To access the values from cell 'C16' of sheet B_sheet1 of B.xls:
• ='D:\[B.xls]B_sheet1'!C16
3. To access the values from cell 'C16' of sheet C_sheet1 of C.xls:
• ='D:\[C.xls]C_sheet1'!C16