Hello,
I have a document that is attached that I would like to be able to have it provide the totals from all numerical columns from each worksheet and then create a summary worksheet from all worksheets within the workbook and provide the totals there. The thing is that all worksheets have their last row of data on different lines based on the number of games a player played in that season. Any help with this would be greatly appreciated. Thanks in advance!
Not clear about the sort of summary you are after - can you manually mock-up what you are after in your sample sheet?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I have included a mockup in the workbook attached with the summary sheet and if you look at the first five sheets you'll see that I went ahead and did the sum manually for all the numeric values and then linked the values to the summary worksheet. Hope this helps. Thank you!
Have a look at the attached. I have started off a solution for you.
1. I've changed the data in the first two named sheets to tables and added a total to the first column.
2. I've given these tables names via the Formulas ribbon - Name Manager.
3. I have used this formula in the summary table in B2 drag copied to B3: =INDIRECT(SUBSTITUTE($A2," ","_")&"[[#Totals],["&B$1&"]]")
I hope it gets you started!
Last edited by AliGW; 02-28-2018 at 12:06 PM.
Thank you for the help to get me started. This is working out perfectly. The only thing that I'm struggling with is how I can get the table to be renamed automatically to the players name with the _ between the first and last name. I have not been able to find anything to help me out with this. Any ideas? Thanks again!!
Last edited by kingsdime29x; 02-28-2018 at 05:39 PM.
I have only just seen this, but am bumping the thread for you. I’ll look in again tomorrow to see if I can help further.
There may be a way to do this using VBA. My advice is to open a new thread in the VBA section asking if there is a way to link the table name to the worksheet tab name.
This formula will get it into an ordinary worksheet cell: =SUBSTITUTE(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)," ","_")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks