| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 104204 | 2009-10-20 00:09:00 | Excel Question-can anyone help? | smurf (6545) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 822231 | 2009-10-20 00:09:00 | I have a workbook consisting of several sheets, each sheet representing a financial record. There probably 10 or so of these. The last page I have set up to summarise the dollar value (Total) represented on each of the sheets. What I am doing at the moment is transferring the individual balance of each sheet from that sheet to the summary page. What I would like to know however, is there a way of automatically transferring each of the individual balances on each respective sheet to the summary page and if so how to set it up:thanks | smurf (6545) | ||
| 822232 | 2009-10-20 00:46:00 | Well if I’m reading this right you can enter a formula ia a cell on the summary page which says: =SUM(Sheet1!A20+Sheet2!A21+Sheet3!A15) To save writing the whole lot just click in the cells you want to add but don’t forget to add the + sign before changing pages. |
B.M. (505) | ||
| 822233 | 2009-10-20 22:43:00 | Thanks BM......it didn't work so I guess it is back to manually entering. :) | smurf (6545) | ||
| 822234 | 2009-10-21 00:04:00 | You could try consolidated tables, where the summary table can be auto updated. But I think the tables require the same structure/setup; Tutorial at Microsoft... (support.microsoft.com) | kahawai chaser (3545) | ||
| 822235 | 2009-10-21 00:07:00 | Is there a cell on each sheet with the total for that sheet or do you want to add multiple items from each sheet into the summary? | stormdragon (6013) | ||
| 822236 | 2009-10-21 07:44:00 | kakawai chaser. Thank you. Stormdragon, thanks for your reply too. The book is a Cash book with each page(sheet) representing and area of expenditure. The cell representing the changing balance for that area of expenditure is the one I want to transfer to a sheet which I call a summary of the individual balances on the various sheets. Therefore if the cashbook say has ten sheets each with its own balance which will change as deposits or withdrawals are made, it is that balance along with that of the other 9 sheets that I want to transfer to a list on the summary page so that I can see a grand total balance of my cashbook which I can then reconcile with my bank accounts. I hope this makes sense:) | smurf (6545) | ||
| 822237 | 2009-10-21 07:54:00 | B.M. is on the rght track here but what you wqant is to make the references absoute by using the $ symbol: =SUM(Sheet1!$A20+Sheet2!$A21+Sheet3!$A15) The actual cell reference you want from each sheet is the final balance. |
Sweep (90) | ||
| 822238 | 2009-10-21 08:08:00 | Thank you Sweep I will try that :) | smurf (6545) | ||
| 822239 | 2009-10-21 08:18:00 | Just want to make sure that you know that you can go "=sum(" then navigate to the sheet and cell you want, click on the cell then push + ..etc. | johnd (85) | ||
| 822240 | 2009-10-21 08:30:00 | Thank you johnd I didn't know that so thank you for telling me :) | smurf (6545) | ||
| 1 2 | |||||