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.

You need to strip out the book name that comes across with the formula.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Geetha" wrote in message
...
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.