Concatenating

[sadath]

I have a sheet with values

ColumnA ColumnB ColumnC
0201533 J000006311 MATERIAL-WELLHEAD & XMAS TREE
0201533 J000006311 TECHNICAL PROPOSAL
0201533 J000006312 BPO-001/04
0201533 J000006312 MATERIAL-WELLHEAD & XMAS TREE
0201533 J000006312 TECHNICAL PROPOSAL
0201533 J000006313 BPO-056/03
0201533 J000006313 SUPPLIER-CAMERON
0201533 J000006313 MATERIAL-WELLHEAD
0201533 J000006313 QUOTATION
0201533 J000006314 JO/SC06/S00
0201533 J000006314 BUILDING MAINTENANCE SERVICES

I want values in Column C to be concatenated depending up the value in Column B

0201533 J000006311 MATERIAL-WELLHEAD & XMAS TREE-TECHNICAL PROPOSAL
0201533 J000006312 BPO-001/04-MATERIAL-WELLHEAD & XMAS TREE-TECHNICAL PROPOSAL
0201533 J000006313 BPO-056/03-SUPPLIER-CAMERON-MATERIAL-WELLHEAD-QUOTATION
0201533 J000006314 JO/SC06/S00-BUILDING MAINTENANCE SERVICES

[JBeaucaire]

Try this macro:

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

[sadath]

JBeaucaire,

After I run the macro, all the cells are blank...For your reference I have attached a sample excel file. Thanks for your time

Sadath

Try this macro:

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook

The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.

[martindwilson]

worked fine for me
here it is after being run