Formulas

Hi Christina, thanks for your query. There is no built in function to do this, surprisingly but with a bit of fiddling it is possible. This link explains the theory:

http://www.meadinkent.co.uk/worksheet-names.htm

...but try putting the following formula somewhere on each worksheet. It will output the name of the worksheet, and you can then dump that value onto the Total page next to the corresponding total amount:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

Hope this helps,

Anthony