Hi all, I have codes in column A like (see below)
A ……….col
400601
401803
401820

and then I have codes and their detail in column E and F
E F……col
400601 Stationery
400601 Stationery
400601 Systems Desk Diary Refill
400601 Sellotape. Wrong Size.
401803 Sellotape
401803 Flip chart pads
401820 Milk pots 530897
401820 Laser paper 530897

I want a macro on a button which should produce result in column B
something like this (see below)
A B……..col
400601 Stationery , Stationery , Systems Desk Diary Refill ,
Sellotape. Wrong Size.
401803 Sellotape , Flip chart pads
401820 Milk pots 530897 , Laser paper 530897

basically in other words what I want macro to do is lets say if I have
code "400601" (as shown above) in column A then macro should check
that code in column E and if it match then check what is the detail in
column F next to that matched code in column E and then put that
detail in column B next to code "400601". If matched codes in column
E are more than one then macro should joint all details which are
coming in column F against that code and put comma between each detail
and then put that in column B. I hop i was able to explain my
question. Please can any friend can help.