I am having trouble putting together code.
I have two rows of data in columns A and B. Row A contains a count i.e. 1,2,3.. etc. It goes all the way down to around 13,000 rows. However for this specific task I only need the macro to calculate until row 1003.
Column A containing the count of data needs to be split into sets of 10, i.e. rows 3-12, 13-22, 23-33 and so on, until row 1003 so the data next to it in column B can be totalled according to the counts.
I have a feeling it has something to do with subtotals, but I have had no success.
I have also attached a small sample of the file for a better understanding of what I am trying
Many thanks in advance for anyones help!