Quote Originally Posted by hobbiton73 View Post
Could you perhaps tell me please do you think it would be possible to use column B as the key, i.e. starting at row 4 find the next empty cell. When it finds this then insert the formula.
I'm not clear..
Quote Originally Posted by p45cal View Post
Will all the SUM formulae end up on the same row on a given sheet (or do you expect them perhaps to be staggered)?
are you now saying that the formulae are NOT staggered?
While there's good column info in your table, I can't tell what the row numbers are. Could you attach a workbook with you next post?