i am working on 2 workbooks. For eg. 2 workbooks, Apr'08 and May'08. Sheet 1
of my both workbooks have 3 associates salary details.I wanted to sum their
salary for each month.
i have a formula in the 2nd worksheet of Apr'08, as
=sum(sheet1!salary1:salary3). this is to find the sum of the salaries of 3
associates. if i move or copy this 2nd sheet to the may sheet to find the sum
of salaries of the 3 associates in May'08, it takes the values from Sheet 1
of the April and not from MAy'08.