How to Cross Reference Between Excel Spreadsheets. Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's ...

Further, I would like to insert a row number in a cell in the summary spreadsheet and use that cell to reference the row number in the formula that references the data in the data spreadsheet.” The ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need.