Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easier way of adding new sheets to workbook | Excel Programming | |||
Easier way of adding new sheets to workbook | Excel Programming | |||
Easier way of adding new sheets to workbook | Excel Programming | |||
Adding sheets to workbook | Excel Worksheet Functions | |||
adding accross sheets in a workbook | Excel Worksheet Functions |