Hello,
Thank you for your invitation!
My name is Chris. As you can see from my profile, I have 16+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project.
How do you want to select the items for the pick lists? The usual way to create pick lists is to have, apart of the inventory table, an orders table, which is used to create the pick lists. If you have online orders, then, except of the inventory webquery, you need also an orders webquery to get the orders; then the program will autmatically create the pick lists. Is this the case? Please contact me to further discuss the details.
Looking forward to hear from you,
Kind regards,
Chris (chriskerpini)