Referring to cells from other worksheets and workbooks in formulas

Most of the budget workbooks you create will have all the values you need…within that workbook.…However, if you want to draw values from other worksheets or workbooks, you can…do so by creating formulas that refer to those outside sources.…In this workbook, which I just have listed as a dashboard that I used to track…my balance sheet, I have my revenue for the year 2010.…I just typed value in.…You can see it's here on the Formula bar.…So, what if I wanted to bring in that data from another worksheet or…perhaps another workbook?…To do that, I need to create a formula that refers to that other cell.…

Here is how you do it.…First is you delete this value and then you type in equal sign.…If the value you want is on another worksheet in the same workbook, then you can…simply click that other worksheet's tab, in this case, LocalData.…The number that I want is my revenue that's here.…You can see up in the Formula bar that Excel is creating the formula for me.…I have =LocalData!C15.…Let me talk about this reference for a second.…