Monday, February 11, 2013

How to Retrieve Values From Another Excel 2007 Workbook


1. Determine the location of the workbook you want to retrieve values from. For example, the workbook might be in the same directory as the one you want to display the values in, and it might be named 'other_workbook.xlsx.'
2. Find the the row and column of the value you want to bring in from the other workbook. For example, you may be looking for a 'total' that is sitting in cell G4 on Sheet1 in other_workbook.xlsx.
3. Type the following formula into the cell you want to display the value from the other workbook on:
=[other_workbook.xlsx]Sheet1!A1
4. Change 'A1' in the formula from Step 3 to the cell you determined in Step 2. In our example you'd change 'A1' to 'G4'.

Blogger news