I'll start out with saying that I am a noob when it comes to Excel and VBA, BUT I am a quick learner.

I have been tasked with creating an excel template that will query an SQL server (AS400/iSeries) and populate a template with purchase order data. In most cases there are several items (or long notes for each item) that can cause the purchase order to span several pages.

Can anyone help me with setting up a template/script to accomplish this? Or direct me where I can find the information?

Thanks in advance.