Merging multiple Sub Numbers into a Cell

[mvinay]

Hello All,

Could someone help me with below:

As i am working on consolidating the numbers manually, whether will it possible for making this automatic.

In Column "A" I have Multiple Duplicate Numbers and followed by the Different Sub Numbers in Column "B". Here i need to manually need to consolidate each number in Column "E" and this is followed by the multipl Sub Numbers in Column "F" in single cell with comma separated to each sub numbers.

Example:

Before Consolidation : (Column "A" & "B")

Number Sub Number
200400001 5
200400001 8
200400001 9
200400001 11
200400001 55
200400001 A
200400001 C
200400001 D
200400001 8
200400001 9


After Consolidation : (Column "E" & "F")
Number Sub Number
200400001 5,8,9,11,55,A,C,D,8,9

Instead of doing this manually can we have the VBA to auto consolidate this numbers.

Here by i am attaching sample file.

[:) Sixthsense :)]

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

Refer the attached file for details

[mvinay]

Hi

I am unable to run the VBA code.

[mvinay]

Hi

I am unable to run the VBA Code.

Could you please help me on this.

[:) Sixthsense :)]

It is an UDF not a Macro Code.

Refer the attached file

[mvinay]

If it is not a MAcro, how will it works??

[:) Sixthsense :)]

If it is not a MAcro, how will it works??

It is a User Defined Function like Vlookup() and other excel functions

I have named it as Clookup (i.e.) Concatenated_Lookup is the hidden meaning of Clookup().

Again refer the provided file

[mvinay]

Got it Thank You so much

[mvinay]

Hi,

This is working, but i have huge data and this is consuming much time to run.

Can i have the Macros for this so that i will provide the desired results for me once i run the macros.

[jindon]

Try the attached.

[AB33]

Try the attached.