Help, probably easy

[N1KO]

Hey,

I could do with some more help, I have a set of values (will be 16
characters long) and they are unique to a certain code (1 code can have
multipul values) E.g.

Code Value
111 000752
111 005894
111 007277
111 012297
111 029580
111 033820
111 046019
111 047341
111 071340
111 072354
111 112763
111 180351
113 006661
113 024007
113 030180
113 036242
113 037290
113 037591
113 037648
113 038938
113 061387
113 066591
113 073563

I need to some macro code/formula to copy and paste the value into another
cell in a list for each Code.

E.g.

Code: 111 in cell A1
List 000752,005894,007277,etc,etc in B1

I need the values to be seperated by a comma and no spaces, they must keep
the 0's infront of the numbers though.

So basically i need to search the column with the 3digit codes in and past
the values that are in the cell next to that code into the same cell in a
list. I need it to do this for every code i have (about 150) with each code
being on a seperate line

Need it to look something like below.

Column A B
Row Code List
1 111 000752,002561,007277,etc,etc
2 113 006661,024007,030180,etc,etc
3
4
5
6


Thanks in Advance

 

[JBeaucaire]

The function I use for this StringConcat by Chip Pearson

http://www.cpearson.com/excel/stringconcatenation.aspx

The benefit of this tool once you install it in your sheet is that it will
take an IF statement.

So if you codes are in column A1:A100 and you values are in column B1:B100,
you could put one of the codes in C1 (111 for instance) and in D1 this
formula would string concatenate:

=StringConcat(",",IF($A$1:$A$100 = C1, $B$1:$B$100,"") )

.....entered as an array formula with Ctrl-Shift-Enter. Works great. The
results would be exactly what you asked for.

 

[N1KO]

Thank You.

Has helped getting the lists but now i need to get each cell with
list in to be less than 250 characters. Where there are more character
i need it to follow on in the next cell down.

Is this possible?

I've attached the file as its easier than typing in the macro code i'v
got.

I could really do with a nested If statement so when i run the Lis
Macro it automatically goes down a row when the cell becomes more tha
250 characters in length.

All help appreciated

+-------------------------------------------------------------------
|Filename: E-mail List Demo.xls
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=74
+-------------------------------------------------------------------