sum Total of columns of populated rows only

Hi all,

Hope someone can help me with this. I have attached a workbook that shows transactions over a period of time.

There are two macros programmed into the workbook thus far, (shortcuts, ctrl+q and ctrl+e). Before the macro's run, there is no gap between the different transaction dates or item bought or sold.

If you press CTRL+q, the transactions will seperate themselves by item, leaving a few blank rows between the transactions

If you press CTRL+e, the transactions will seperate themselves by date ,
leaving a few blank rows between the transactions

What I need now, is a method to total the columns B(quantity) and columns D(price) of each grouped transaction and to place the totals on the first blank row after each specific group of transactions.

I have made worksheet 2 to show what the ideal end result would look like.

Please can someone help me with this, would really really appreciate it

If you need any additiona information from me, please just ask and I will try my best to respond immediately.

Thanks so much in anticipation

Regards,

Paul

Here's a third instalment. I expect you could combine all code into one procedure.

Please Login or Register  to view this content.

this works really well thank you.

Sorry, would it also be possible for you to show me how to show the values in the remaining columns?

So that the date would be shown in column A, Buy/Sell would be shown in C, currency in E etc?

thanks again btw

Try this:

Please Login or Register  to view this content.

Stephen

thank you so much

it works absolutely brilliantly

I am really so grateful

Have a great day

Regards

Paul