+ Reply to Thread
Results 1 to 4 of 4

VBA to copy/clear rows based off option buttons/checkboxes

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2010
    Posts
    15

    VBA to copy/clear rows based off option buttons/checkboxes

    Hello everyone,
    I have warehouse pick list I'm developing that will give people a list of parts to pick based of selected model and options.

    I just need when option buttons/checkboxes are selected to copy over the entire row where the parts have the identifier for that option over to the "PickList", and when options are changed or checkboxes de-selected to remove those rows.

    It has the full list of parts on Sheet1 ("PartList"), and the model/options selections on Sheet2 ("Model Setup"), and the pick list on Sheet3 ("PickList") that is compiled by the selections on "Model Setup".

    There is a column in "PartsList" that has identifiers for models/options those parts belong to.


    I made a big IF statement for the "PickList" that already pulls the parts based on model selected. But I still need the options. I have searched for about half a day trying to find a VBA I can modify to suit my needs to no avail.

    I have included attachment of my project.

    I just need someone to get me started,

    Thanks sooo much!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-21-2012
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA to copy/clear rows based off option buttons/checkboxes

    No takers yet?

    I have an update to the project file.

    I am happy to provide additional info


    Thanks
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA to copy/clear rows based off option buttons/checkboxes

    The Option "identifiers" are in column F on the "PartsList" sheet.

  4. #4
    Registered User
    Join Date
    09-21-2012
    Location
    Minnesota, US
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: VBA to copy/clear rows based off option buttons/checkboxes

    I just decided to do a big IF statement for every cell in another sheet to accomplish what I needed, due to no response and no adaptable (by me anyway) versions found in other threads/forums.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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