Quote Originally Posted by Glenn Kennedy View Post
I have done this for a few of the "total" rows (coloured green) and for a range of the individual rows (coloured yellow).

Total rows. Copy the content of E22 into the next total cell (E103). Replace "6" with desoired target cell row, which is 550 Then drag to the right.

Individual rows. First work out the formula that you need. Your next individual row is in sorter E105. It is drawing data from the other sheets E572. The formula adjustment you need is

source row-(row()-destination row)/2 i.e. 572+(row()-105)/2 This will give you a result of 572, two rows down it will give you 573, etc, etc.

Then copy the formula in E26 into E105. Edit the formula replacing everything from the last & to the last bracket witht he phrase above. Copy across. Copy and paste into the individual rows, one at a time until you getto the next total row.

Repeat until you get to the end.

Relax.

If you do run into problems, shout... I haven't completed the exercise as I don't know howfar down your master sheet that you have to go.... I've left my "working notes"in the sheet (columns P & S) which you can delete.
Sry for not replaying yesterday, the master sheet start at row 6 and ends in 1776 and koloum starts in E and ends at N. Will try to add all master sheets today so there will not be any friday party for me hehe. Thanks for the amazing help guys, will throw in all masters sheet today and try to understand how everything works!

Will also try to add the same drop-down list that "davesexcel" made to try to skip the extra sheet. Will get back if i get stuck somewhere