Need Excel VBA to categorize product from list1 to list2 by filter multiple values

Dear experts

I need an help of vba code on userform to assisgn value from category filter then from segment filter

at end list of data view from depend upon category combobox1 and segment combbox2

i want options mutiple value select and pick category in combobox3 and click command button to save data into sheet "Backup_Data"



for e.g
if i have 20 data in furniture

if i select 10 data and click cmd button Amart furniture those 10 data move to Backup_Data with Amart furniture In col E:E
remaining 10 data
if i select only corporate and click cmd button only corporate value data move to Backup_Data

find the attachment

i explain in sheet Report_Form with example.

Hi boss

thanks for help me, i want add on combobx shipping list and works command button, selected and marked item will be clear off in listbox

i found example file from the forum.

[
i enclosed file

after listout data view in listbox1 i want option multiple pick vlaues in listbox1 then select shipping status and click then click categorized button,

data save to back_up sheet

if i pick up Only Corporate from shipping to then click categorized only corporate data move to listbox2
if i pick up only coustomer from shipping to then click categorized only coustomer data move to listbox2



find the image explaination

Hi Boss

Data filterd and view in listbox from Rawdata, once i select and move by command button it goes to backup sheet,

Action_1 in Combobx1 Filter any Category

Action_2 in combox2 Filter either All or Coustmer or Corporate
(if all both customer and corporate to show)
if coustomer only customer data
if corporate only corporate data

Action_3 i want pick option one or mutliple line item from listbox1 listdata

Action_4
selection operation i want select shipping type from combobox3 and click Categorzied button
for e.g if i select 5 data in listbox1 and select in Bed Bath N' Table combobox3 and click categorzied button those 5 data goes to listbox2 to see at the same time goes to save at backup sheet with today date.
another different scenerio
this action not selective operation, pick operation in combobox3
1.if i select Only Corporate in combbox3 and click categorzied btn only corporate data from listbox1 to listbox2 view at the same time goes to backup sheet
2.same for Only customer also


find the userform
simple if 30 item in listbox1, i select 10 item move to listbox2 from combobox option once cmd button 10 item goes listbox2 rest of show only listbox2
remaining 20 in listbox1

Hi Boss

I want make so simple filter data,select data,move data by category moved data save to backup sheet, your work is total out of my box

please help on my sheet, easy for me to learn code and procedure

hi Boss sorry for requesting you as of now what you done is perfect, i just add one more option to make dream form alive.

i add dropdown option for shipping details from listdata sheet E & F

Find the attachment i getting error of select all, i add select all and unselect all

Please boss, last requirement greatful to you ever!!

Thanks alot Boss!! Great Work solved

i dont have reputation left with me to do for u,