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