merge by vba

[waqas]

I have values in cells
61A
61A
61A
61B
61B
61B
61C
61C
61C

I want to merge by*vba*61A in one group*
61B and 61C as well. These values might be different base on result.
It can be increased or decreased.

Can any one tell me code of*vba:cool:

[Sixthsense..]

A simple Pivot Table will do it for you :hi:

[waqas]

A simple Pivot Table will do it for you :hi:

But i need by vba code not by pivot table

[Sixthsense..]

Since your shown data consist only single column, so in this case the Remove Duplicates will do it for you.

Use Macro Recorder and try Remove Duplicate method.

[waqas]

These are 9 cells and cells can be increased base on value.
You can put different values are same values in other columns. I need this first column to be merge. Select 61A and merge it to show single value with three cells in 2nd column but in vba.