Good day,
Every three months I have a report downloaded from an accounting program to Excel.
The report contains data running from columns A-J and down as far as row +- 35000 depending on the period.
I use a formula which, based upon certain criteria in each row, will give me a value in column M. Every so often (no set pattern) a value (eg: ‘CDWNH2336’) will occur in column A and then again slightly further down in the same column. I will have to total the figures in column M in the same row as that second(CDWNH2336) appears, and only the values that occur in between both values.
Ie: CDWNH2336 occurs in A4 and then again in A32. I have values in cells M5,M7,M29,M31. I will need to total them in row 32 (it does not matter in which column as long as it is line with the second CDWNH2336). I will need a macro that maybe searches for blank cells in between the two CDWNH2336’s, then sums column M for those blank rows and displays that data in line with the second CDWNH2336.
I hope that made sense at all. I will send a fragment of the sheet to anyone willing to try this. This will cut out ALOT of manual labour and I would highly appreciate it. Not too sure how else to describe this… So, I eagerly await someone with VB and Macro knowledge to astound me.
Thanking you,
Wayne
