To pull data from another sheet in Excel, use cell references, use the VLOOKUP function, or use the INDEX and MATCH functions.

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

Q. I have an amortization schedule arranged vertically in Excel on Sheet 1 that I want to reference horizontally in my income statement on Sheet 2. Is there a way to write and copy/paste a single ...