Okay, I have been doing this a while, and I should know this. I actually have attempted to exhaust all my reasonable resources prior to posting...but I just cannot find the right code.

Here is what I am wanting to do. I have a userform that generates a bill of material for different parts held within NAMED tables and NAMED rows. Basically our user will prompt the UserForm by button (I have the part done). The user will select between sizes and classes handled by checkboxes (I have the code written to at least prompt the correct message box if certain things are selected). NOW, I am lost. I want the user to be able to click "Order", and it will pull the bill of material on a separate sheet ("Sheet1") and place it on the next empty row of a specific column ("PartName"). Again the tables are built as tables with names and everything, and the table the order form is on is also built as a table...

WHAT DO I DO??? HELP!!! I have to do this for over 70 different assemblies, and learning how to do it once, will suffice all these requirements, but I am lost. Any help is greatly appreciated. If uploading the spreadsheet will help, I will do that also.