Concatinate and remove duplicates using vba macro using autofilter criteria

1 2 3 4 5 6 7

car A apple1 orange1 22 23 24
bat A apple1 orange1 12 34 56
bus A grape1 cherry1 13 56 67
cat A grape1 cherry1 23 45 78
fat B peach1 mango1 12 13 14
van B peach1 mango1 13 24 16
gun B berry1 banana1 13 67 99

1..Here i hav apply auto filter for 2nd field ie A and B, and i should enter the Criteria for the autofilter through message box
2..If I enter A , here the 5th col value should be concatinated,for the repeated rows,
out put :
car A apple1 orange1 22/12
bus A grape1 cherry1 13/23



3...if i enter B,
fat B peach1 mango1 12,13,14/13,24,16
gun B berry1 banana1 13,67,99


Please find solution for this

Hi

i will get back to you tmrow

Hi, chakravarthysm,

you would need to elaborte why Column A should be neglected and why for character A only Column E should be concatenated while for B the Columns E to G should be concatenated. Are there more of these special cases to care for? Maybe you should attach a workbook with sample data and explain hte basic data, the list of which character will concatenate which column/columns and a sample how the data should look like.

Ciao,
Holger