So I keep a spreadsheet data that needs to be submitted at various times during the year. When we submit the data it needs to be place into a basic form that was built in excel. The forms have about 15 different fields that need to be filled in the form for each submission and we probably submit about 200+ forms a year.

Instead of typing in the information for each form for each submission can I make excel automatically fill in the information from the data sheet already in excel?

Ideally I would love to be able to pick a row of data, hit print and out prints the form completely filled out.

Any ideas?