Copying entries from multiple sheets to new sheet, then summing
Solved/Closed
polyrhythm
Posts
1
Registration date
Sunday November 8, 2015
Status
Member
Last seen
November 8, 2015
-
Nov 8, 2015 at 10:33 AM
nahidule Posts 2 Registration date Sunday November 1, 2015 Status Member Last seen March 11, 2016 - Nov 9, 2015 at 10:00 AM
nahidule Posts 2 Registration date Sunday November 1, 2015 Status Member Last seen March 11, 2016 - Nov 9, 2015 at 10:00 AM
Related:
- Copying entries from multiple sheets to new sheet, then summing
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Little alchemy cheat sheet - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Nov 9, 2015 at 09:46 AM
Nov 9, 2015 at 09:46 AM
I think you would need to create a macro to create the cummulative sheet or atleast update the sheet
this is how i would have proceeded
1. copy from sheet1 to sheet5, the team name in a temp sheet, in a single column
2. use advance filter to get the unique list
3. copy the unique name to commulative sheet
then you can use vlookup easily
this is how i would have proceeded
1. copy from sheet1 to sheet5, the team name in a temp sheet, in a single column
2. use advance filter to get the unique list
3. copy the unique name to commulative sheet
then you can use vlookup easily
nahidule
Posts
2
Registration date
Sunday November 1, 2015
Status
Member
Last seen
March 11, 2016
Nov 9, 2015 at 10:00 AM
Nov 9, 2015 at 10:00 AM
Nice, helpful resource.