Excel question

[Tefler]

I'm trying to create an ongoing attendance register. On worksheet 1, I've got possible attendances and actual attendances. This allows me to record absences and percentage attendance for any particular week. However, I want to keep a running total of possible attendances, absences and % attendance. This means that I have to add this week's possible attendances to last week's, etc. from the previous worksheet. I'd be grateful if somebody could point me in the right direction.

[Jumbuck]

When you create a formula you can use the mouse to select the cells you want to use in that formula e.g if you want B3-F7 then (after selecting the '=' for the formula format) click on cell B3, type '-', then click on cell F7 and click on the tick.

The important thing for what you want to do is that those cells that you click on can be on another worksheet - the name of the worksheet is prefixed to the cell id.

I don't have Excel available to me currently to let you know the exact form of what gets put in the formula as a result - I think its 'sheet name':B3 etc.

[Tefler]

Sorry, Jumbuck, for the delay in replying, but I would like to thank you for the help. I'll give that a go. My problem was definitely getting things to transfer from previous worksheets.