Christina has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Formulas
If you have 4 worksheets named:
Savings
Spending
Earnings
Total
Is there a way to pull through the worksheet names on the Total page next to the corresponding total amount?
Thanks
RE: 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
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
