When we use microsoft Excel ( I use excel 2007) we can get value from other sheet in the same file or from other file, here I give example from the same file but difference sheet
1. I have sheet “ScoreScience” and “ScoreMath”
2. Next I want to create new sheet that get value from both score sheet to get average value. Fill your formula like this [SheetName!CellPosition]:
Hope it well help you.
No comments:
Post a Comment