When working with multiple sheets in an Excel workbook, you may need to reference data from one sheet to another for calculations, analysis, or to keep your workbook organized.

You have an Excel 2011 spreadsheet compiling sales data and a sales report that you're writing in Word 2011: How do you get the Excel numbers into your report? Here's a simple Visual Basic macro ...