Hi everyone, I am re-wording my original query to try an clarify the issue
and hope someone can help:
Data is copied into a workbook starting with Row 7 Cell A7
In the example below:
Col B Col C Col W Col X Col Y
Row 7 1.30A 1 +80
Row 8 2
Row 9 3
Row 10 4 -20
Row 11 5
Row 12 6 -10
Row 13 7 +50
Row 14 2.00B 1
Row 15 2 +60
Row 16 3
Row 17 4 -20
Row 18 5 +40
Row 19 2.30A 1
Row 20 2
Row 21 3 -10
Row 22 4 -10
Row 23 2.45C
Etc. Etc.
What I am doing re the above example is as follows:
Manually copy and paste the formula:
SUM(W7:W13)+SUM(X7:X13) in cell Y13,
one row above new entry in cell B14
SUM(W14:W18)+SUM(X14:X18) in cell Y18,
one row above new entry in cell B19
SUM(W19:W22)+SUM(X19:X22) in cell Y19,
one row above new entry in cell B23
Etc. Etc.
The blocks of data can vary from 4 to 25+ rows and are randomly different.
The "Total" cell with the formula in col Y is always one row above
the new entry in col B.
I hope this is clearer than my previous query and that someone can help me.
I am trying to automate what is essentially a time consuming task.
Thank you all in advance for your help.