Results 1 to 4 of 4

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

Threaded View

CWicklund VBA to copy/clear rows based... 01-22-2013, 01:05 PM
CWicklund Re: VBA to copy/clear rows... 01-28-2013, 05:23 PM
CWicklund Re: VBA to copy/clear rows... 01-28-2013, 05:26 PM
CWicklund Re: VBA to copy/clear rows... 01-30-2013, 03:41 PM
  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

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