A
ArcticWolf
Hi,
I have some VB code (an answer from another question) written by vezerid
which I found very useful and have used in my sheet.
On the extra row that is being created - is it possible to sum the cells
above (of
certain columns) please?
I've used the VB below to put an extra row in after every change in team
name within my organisation (column A). Some teams have 10 people in, while
others have 100+ so putting this blank row automatically is very useful to
separate.
I then go through the sheet and manually sum the columns required (T, U and
BK)
for each team. I've tried to amend the code myself but I can't seem
to get it to work properly, as some of the 'sums' are for the 10 rows above
and then some are for 100.
Is it possible to amend the code to include the sum for these 3 colums
please?
Thanks in advance,
AW
I have some VB code (an answer from another question) written by vezerid
which I found very useful and have used in my sheet.
On the extra row that is being created - is it possible to sum the cells
above (of
certain columns) please?
I've used the VB below to put an extra row in after every change in team
name within my organisation (column A). Some teams have 10 people in, while
others have 100+ so putting this blank row automatically is very useful to
separate.
I then go through the sheet and manually sum the columns required (T, U and
BK)
for each team. I've tried to amend the code myself but I can't seem
to get it to work properly, as some of the 'sums' are for the 10 rows above
and then some are for 100.
Is it possible to amend the code to include the sum for these 3 colums
please?
Thanks in advance,
AW