PDA

View Full Version : merge by vba



waqas
06-08-2015, 05:21 AM
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..
06-09-2015, 12:40 AM
A simple Pivot Table will do it for you :hi:

waqas
06-09-2015, 07:50 PM
A simple Pivot Table will do it for you :hi:

But i need by vba code not by pivot table

Sixthsense..
06-10-2015, 12:48 AM
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
06-10-2015, 10:51 AM
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.