Excel, VBA, Conditional insert row, conditional sum range

[luvbite38]

Hi guys,

thanks in advance for any suggestions and solutions.....

I have a summary worksheet which summarises the list of diffirent items.

I want to create a macro which insert a blank row if the value is changed in column B and than in the newly added blank row, sum the total/ item type (there are 8 types in each item).

See attached a sample workbook, there are two worksheets in attached workbook first worksheet is my existing summary page and second is my desired summary.

I hope the attached workbook will help to understand my question better.

Thanks once again for sparing time to fix this issue.

Regards

I didn't know how to attach file into the post, so I have upload the file on mediafire: Link below.

Could also tell me a better way of uploading the file in MrExcel please

http://www.mediafire.com/?cmt91xhyt11s631

 

[luvbite38]

The sum range is variable.

Thanks Thanks Thanks

 

[luvbite38]

just in case if the file is not accessable.... my current summary page is as below:

item total
apple1 1
apple2 2
apple3 2
apple5 2
apple8 9
b1 4
b8 6
grapes4 9
grapes6 11
grapes6 12
grapes6 10
grapes8 1


pls help....

****************Required


apple1 1
apple2 2
apple3 2
apple5 2
apple8 9

APPLE 1 = 1 APPLE2 = 2 APPLE3 = 2 APPLE4 = 0 APPLE5 = 2 APPLE6 = 0 APPLE 7 = 0 APPLE8 = 9

b1 4
b8 6
b 1 = 4 b2 =0 b3 = 0 b4 = 0 b5 = 0 b6 = 0 b7 = 0 b8 = 6

grapes4 9
grapes6 11
grapes6 12
grapes6 10
grapes8 1
grapes 1 = 0 grapes2 = 0 grapes3 = 0 grapes4 = 9 grapes5 = 0 grapes6 = 33 grapes 7 = 0 grapes8 = 1