Updating mutiple links in excel

04-Nov-2015 22:31

Consider a Sales Manager who has a detailed spreadsheet for each salesperson, but would like a summary sheet to compare salespersons' performance and create grand totals. In the example below, using Method One, we click in cell B6 in the source worksheet and click Copy.

This is just one of many reasons the Excel software program is so powerful.The ability to create links often eliminates the need to have identical data entered and updated in multiple sheets.This saves time, reduces errors, and improves data integrity.For example, a company's prices can be stored in a 'Master Price List' worksheet, and others needing pricing data can link to that worksheet.Microsoft Excel provides the ability for cells in one worksheet to be linked to cells in one or more other worksheets.This is a great productivity tool and can reduce the need for additional worksheets!

In this tutorial, you will learn how to link worksheet data in all versions of Excel.

You will also learn hints and tips on how to work with this cool feature.

In Excel, a link is a formula that dynamically pulls in data from a cell in another worksheet.

The worksheet can be in the same workbook or a different workbook.

The destination worksheet contains the link formula, and it receives data from a cell in the source worksheet.

Any time the cell value in the source worksheet changes, the cell containing the link formula will be updated as well the next time it is opened.