Merge cells depending on number of other cells

[FrederikBjerre]

Hello people,

I would very much like to create a mergecells-macro.
First a short description of my case. I have choosen to "dummy" it a bit so its easier for me to explain, so don't be fooled by the low number of input data and so :-)

I have 2 columns, person and task(s). (One person might have several tasks)
In one sheet (Sheet2) the person writes his name in column A and his tasks in column B ie:

A -------- B
Ben ----- Clean
------------Wash
------------Cook

Now I would very much like to have a macro, that cut/paste this data into another sheet (Sheet1) - the "overview" sheet. I have made a macro that does this, but now I would like to make a macro that merges the cells in column A so that it fits the height of the 3 tasks in column B.

How is this done? Can't seem to find a macro that "counts" the number of cells to merge from another column. And if I could get it to count it, how can I tell the macro what NUMBER of cells below it should merge?

I hope it makes just a little sense and I hope that someone can help me.

Thanks in advance

Br
Fred

[watersev]

hi, Fred, that's not exactly what you asked for but may be you will accept it as a good substitution, check attachment, press "Start" button

[FrederikBjerre]

Hmm it doesn't seem to solve my problem? I only have the name one time :-(

Any other takers?

[watersev]

hi, FrederikBjerre, please check attachment, run code "test"

PS. In order to avoid any misinterpretations of your task it's recommended to post sample workbook showing original data and the result you need to obtain