Friday, December 21, 2007

Excel - refering cell data from one sheet to another

Sometimes we need to work on Excel sheet and its good to know some of the functions. When we need to create subtasks as multiple sheets and summary sheet. Summary sheet need to get the total from subtasks and provide grand total.
Copying the total into summary sheet would help, but what happens when we change some value in subtaks sheet, again the same value need to be copied. It is better to refer subtasks sheet value in the summary sheet. It is simple! Assume subtasks sheet names are "TAB1" & "TAB2", so in the summary sheet in the particular shell type

='Tab Name'!$ColumnName$RowNumber
example,
='TAB1'!$B$10
='TAB2'!$B$10

so whenever there is a change to subtasks this will be reflected immediately in summary sheet.

No comments: