How do I pull data from one worksheet in Excel 2007 into another worksheet, and be able to link the data; so when I update data in one worksheet it would automatically update the resultant formula in the other worksheet. There are many ways to link data from one worksheet to another when it comes to formulas; however, to most basic way when not using a formula is the equals symbol. Add that to any cells and point it to another worksheet, or even a workbook and it's linked. Once linked you'll be able to receive automatic updates to data that the formula is dependent upon. This can help you organize your data and spread it out among worksheets or workbooks!

Purchase the training video and you can see this in action for yourself!