I have a data base built using advance filters and user forms.
Raw Material is order and received in, the order information along with other data is entered manually into a header based data spread sheet "page" where later this data spread sheet page can be searched using the advance filters and user forms for particular information from particular orders.

What I need to do now is generate a router sheet "form"
This form would need to be populated based on the row that the "just received in" material information was entered into. Then printed out all by using a command button named "generate route sheet"

I know how to take copied data and import it into a PDF form with the fields that match the headers in the data spread sheet page. BUT the people using this database are not capable of such a task as to the one button solution request.

any and all suggestion would be appreciated.