View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
swtupr swtupr is offline
external usenet poster
 
Posts: 17
Default Adding cells from different sheets of same workbook

Hi,
I have this very weird problem with my excel formula. Hope somebody can help
me. In Sheet5 cell J8 i have this formula

=Sum(Sheet1!J8,Sheet2!J8,Sheet3!J8,Sheet4!J8)

Whenever i change some cell in Sheets 1,2,3 or 4 the focus automatically
comes to sheet5. Change means deleting anything in those sheets or entering
some new data.
Did any one have the same issue. Please HELP!!!

Note: I have large amount of data in sheets 1,2,3,4. About 500 rows in each
sheet. And nothing in Sheet5 except for this formulae for diff cells J8:N10

Thanks.