Forum Discussion
Excel formulas and functions
When you enter a formula, you just have to navigate to the other sheet within the workbook, and make the cell(s) from the other sheets part of the formula. In other words, start from the sheet where you want the result to appear, then create the formula by selecting the proper cells in the other sheets. You can select data from any other cells, either from sheets within the same workbook, or even pull from other workbooks. Make sense?
When you enter a formula, you just have to navigate to the other sheet within the workbook, and make the cell(s) from the other sheets part of the formula. In other words, start from the sheet where you want the result to appear, then create the formula by selecting the proper cells in the other sheets. You can select data from any other cells, either from sheets within the same workbook, or even pull from other workbooks. Make sense?
