CONCATENATE rows and copy to specific rows when values change in between different values

Hello

I have a lot of workbooks, which have to be decomposed in the same way.

I have the ollowing code to insert new rows when the value in column B changes and insert text into those rows:

Please Login or Register  to view this content.

However, I now have to CONCATENATE the values between the inserted rows, because in column A I have different numbers, and I have to take the lowest number and the highest number in between those rows and copy paste it to the cell next to the strings (Begin-total and end-total), so that would be in column C in this example.
I have attached a little example...

I have found this code in another tread, however as I wrote, I need it to take the values from the rows between the blank values - this one only take values below the blank cell and paste it above, I need it to both paste it above and below (so the same value appear twice.

Please Login or Register  to view this content.

Can anyone help me how to tweak this code to do the job?
Thanks in advance, appreciate any tips.