Need VBA Code to find unique combinationlist in Column B and move to sht

[breadwinner]

Dear experts

i have rawdata of combination of segment, i want split unique values to Dock_1,2,3...sheets depends upon repeating count value
Column c= repeating count values 1,2,3,.... Depends upon column repeating value 1,2,3 i want split only unique one combination.

like for example :keyword combination
ERTG_1
BSQR_RECK(1)
ERTG_3
repeats twice i want copy one time in sheet Dock3,in column A:A Dock1_1 for copy of unique,

find the attachment

[Marc L]

Hello,

it seems your first column in expected Dock #2 & 3 is wrong so attach at least a workbook without any result error …
If there is no error then you must clearly explain the rules to follow for each special case !

Edit : as Docks columns B contains errors like Master column E as well …

[breadwinner]

hi sir

please find the attachment

i think i make correction with perfect requirement. complicated part is the key word not in same series phrases some times 1,3,2, or 3,1,2

[JohnTopley]

Excel for beginners version !!!!

Please Login or Register  to view this content.

[breadwinner]

Thanks alot master JT solved!!!, It works perfect

[breadwinner]

Hi Master sorry for bother you, i need a help on code what u gave, if i extent the sheet like Bill_4,Bill_5...till Bill_13 where do make change in code of line

just mark in code i do accordingly

thanks

[JohnTopley]

Please Login or Register  to view this content.

Just guessing but another example of not providing a COMPLETE requirement in the first place.

All references to "Dock" need extra coding to account for "Bill".

[jindon]

breadwinner,

This finds all the possible combination based on col.C of master sheet.

Please Login or Register  to view this content.