Hello team.
I have a range that has a date column and a value column. Next to the dates, there are values with either a positive or a negative value.
The range in columns A to D can be dynamic, i.e. the total number of rows can differ from month to month.
The columns will not change position, they will stay the same.
I would like to loop through the range and sum the numbers with positive values for a specific date and paste them in the corresponding date row, under the positive column.
Similarly, I would like to loop through the range and sum the numbers with negative values for a specific date and paste them in the corresponding date row, under the negative column.
Please see the before and after shots below of what I would like to achieve.
I'm still in the throws of a VBA course and I know how to loop through ranges and select data I need. However, what is outlined above and what I would like to achieve, is well beyond me at this stage.
Any help would be greatly appreciated.
Thanks
Brad.
I have a range that has a date column and a value column. Next to the dates, there are values with either a positive or a negative value.
The range in columns A to D can be dynamic, i.e. the total number of rows can differ from month to month.
The columns will not change position, they will stay the same.
I would like to loop through the range and sum the numbers with positive values for a specific date and paste them in the corresponding date row, under the positive column.
Similarly, I would like to loop through the range and sum the numbers with negative values for a specific date and paste them in the corresponding date row, under the negative column.
Please see the before and after shots below of what I would like to achieve.
I'm still in the throws of a VBA course and I know how to loop through ranges and select data I need. However, what is outlined above and what I would like to achieve, is well beyond me at this stage.
Any help would be greatly appreciated.
Thanks
Brad.