Auto Fill a Form from a Database

[PaulMelloy]

I have created a database for job lines in a plumbers that I work, for tracking new jobs. The database is completed using a data entry form to provide a new job number to a job.

I have also set up a blank job line that gets printed out to give to the engineer that is going to this job.

I have seen a database where you can create a button to auto complete details from the database sheet by entering a matching number into one of the cells, and I know that this is created through macros and ActiveX buttons, however, that is beyond my understanding.

Would someone be willing to have a look at this for me to create the button to update the printable page ?

 

[Fluff]

Hi & welcome to MrExcel.
If I understand you correctly, this can easily be done using a Vlooukp or Index/Match formula.

Can you post some sample data from both sheets? There are add-ins available here to help with that. https://www.mrexcel.com/forum/about-board/508133-attachments.html