I am creating a template for my paystubs where my clerks can copy and paste the template into the next paystub.
What I would like to do is create a running total for the YTD sections (Year to date) which would be the sum of all the previous sheets INCLUDING the current one.
the code =Sum('*'!A16) works well except it did not include the current worksheet.
There was also the code =SUM('2017 January 5:[DATE]'!A16,'2017_End'!A16) but I want to replace [DATE] with the current worksheet.
Basically what I'm asking is how to use:
=Sum('*'!A16) and include the current worksheet
find the coding that represents CurrentSheet or something along those lines so that =SUM('2017 January 5:[DATE]'!A16,'2017_End'!A16) the bold portion can be replaced with CURRENTSHEET or whatever the coding may be for such a request.
Thank you for any and all help!