How to Wire a Macro to Pull From One Spreadsheet to Another

1. Open Excel 2007 and find a workbook. Click the 'Office' button and select the 'Open' icon. Browse your files for the workbook. Click the workbook and click 'Open.' The workbook opens.
2. Click the Developer tab and select 'Record Macro.' The Record Macro dialog box appears. Enter a name for your macro in the Macro Name field. Add a brief description in the Description field. Click 'OK.' The macro starts recording.
3. Link two spreadsheets together by clicking on one cell in your first worksheet. Type '=.' Click on the second worksheet and select a cell that you want to link. Click that cell. Press the 'Enter' key. These two spreadsheets are now linked and the first worksheet will be populated with data pulled from the second worksheet.
4. Click 'Stop Recording' on the Developer tab. You have completed the recording macro process.