Simple Merge Cells (Macro)

[boss1982]

Hi,

Please i want some help to do one simple macro;

i have this table

eee1 eee2
1 a
1 a
1 b
1 b
1 c
1 c
1 e
1 e
1 e
1 e

and i want the macro to do the following output;

eee1 eee2
1 a
1
1 b
1
1 c
1
1 e
1
1
1

as rows A2,3 showing merged cells in column B as "a" in merged rows B2,3

it is big excel sheet, i mean the column B is very long and i need to merge sometimes 2,3.....20 cells togather.

please help

[patel45]

can you attach a sample file ?

[boss1982]

thanks for your reply, please find attached file as requested

[patel45]

Please Login or Register  to view this content.

[boss1982]

hi patel,

i used it in the same file and its working fine, but in another file no, i attached again a sample of the file which i want (2 sheets).

can u please give me the code again?

thanks a lot.

[boss1982]

any help plz?

[boss1982]

any one can help plz?

[boss1982]

ok thanks

i did it

[jindon]

try

Please Login or Register  to view this content.