+ Reply to Thread
Results 1 to 18 of 18

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

  1. #1
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

    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.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Hello.
    In the proposal that I attached the comboBox's work as independent filters.

    Now what I don't understand is an aspect of the copies to the 'Backup' sheet...
    This is: after making the copy, do you want that data to be deleted from the Rawdata sheet?...

    Please Login or Register  to view this content.
    Attached Files Attached Files
    You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.

  3. #3
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    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
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Actually I asked you something else:

    Quote Originally Posted by beyond Excel View Post
    Now what I don't understand is an aspect of the copies to the 'Backup' sheet...
    This is: after making the copy, do you want that data to be deleted from the Rawdata sheet?...
    ________________________________

    Regarding your last post, please use your own workbook (post #2) and comment on a concrete example. I mean:

    - Select such a thing.
    - And send the selected to such other side.

  5. #5
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    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
    Attached Images Attached Images

  6. #6
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Everything you've been describing can be done with a single listBox.

    But what you haven't explained is: if you copy some records to the 'Backup' sheet... Do these records have to be deleted from the 'Rawdata' sheet?

  7. #7
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    At the top right of the Userform you can select two lists:

    - Rawdata (the original data), or
    - for Backup (the original data selected for backup).

    The two comboBox continue to fulfill their function of filtering the data.

    You can now select individually or all the records in the listBox. When you do, these rows will become part of the 'for backup' list.

    And when you select one or all records from the 'for backup' list, they will be moved to the original 'Raw Data' list.

    From now on I will wait for you to answer what I have already asked you twice.
    Attached Files Attached Files
    Last edited by beyond Excel; 02-28-2023 at 03:22 PM.

  8. #8
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    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

  9. #9
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Your answer to my question is still pending.

  10. #10
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    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
    Attached Files Attached Files

  11. #11
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    As you can see in the attached video, the Userform does everything you mentioned:

    - Various types of filters.
    - Individual filtering of records
    - Filtering of everything seen in the listbox
    - And movement of the records to the backup sheet.

    Attached Files Attached Files
    Last edited by beyond Excel; 03-02-2023 at 06:41 PM.

  12. #12
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    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
    Attached Images Attached Images
    Attached Files Attached Files

  13. #13
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Quote Originally Posted by astray88 View Post
    hi Boss sorry for requesting you as of now what you done is perfect...
    Don't you think it's time to thank what I've contributed so far and click on the * below and to the left of post #11, as is customary in this Help Forum?...

  14. #14
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    Please boss, last requirement greatful to you ever!!

  15. #15
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Quote Originally Posted by astray88 View Post
    Please boss, last requirement greatful to you ever!!
    Again:
    Don't you think it's time to thank what I've contributed so far and click on the * below and to the left of post #11, as is customary in this Help Forum?...

  16. #16
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

    Thanks alot Boss!! Great Work solved

  17. #17
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

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

    Again:

    Don't you think it's time to thank what I've contributed so far and click on the * below and to the left of post #11, as is customary in this Help Forum?...
    Screenshot_20230306_063249_Firefox.jpg

  18. #18
    Registered User
    Join Date
    02-24-2023
    Location
    sydney
    MS-Off Ver
    2019
    Posts
    39

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

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to categorize source worksheets to destination worksheets based on product type
    By choletseng in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-19-2022, 10:01 AM
  2. [SOLVED] Loop with finding text strings in List1 and find in List2 text strings.
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2020, 11:43 AM
  3. [SOLVED] How to Categorize Product Contain Same Words
    By valdanov in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-07-2019, 12:02 PM
  4. Comparing two lists and printing elements of list1 that are not in list2+3
    By Nazariy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2014, 11:20 AM
  5. Cross Categorize Product Data - Who can help with this?
    By LionBear in forum Excel General
    Replies: 1
    Last Post: 06-16-2012, 10:25 AM
  6. List2 based on List1
    By Hasnain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-10-2008, 03:45 AM
  7. I have a list1 and a list2, I want to remove list2 from list1
    By snow in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2006, 02:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1