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!
Bookmarks