Excel Macro - Help need to group serial numbers

Hi, does anyone have some code that could do the following? Column A is Invoice, column B is Serial:

BEFORE

INVOICE	SERIAL
1000	ABC1
	ABC2
	ABC3
2000	ABC4
3000	ABC5
	ABC6

AFTER

INVOICE	SERIAL
1000	ABC1,ABC2,ABC3
2000	ABC4
3000	ABC5,ABC6

In short, group all serial numbers for an invoice on one line in column B beside the invoice, comma separated.

In the right hands this would be easy, in mine impossible!

Many thanks in advance.

Baz

Hi Baz

Try this:

Please Login or Register  to view this content.

Cheers, Rob.

Rob, you are a genius! Your code was spot on.

I hope wherever you work is paying you a bucketload!

Baz.