vlookup to loop through rows

[dantray02]

Hi,

My workbook contains four sheet: input, letter 1, letter 2, data

Data contains customer records, column A is numbers 1-500

Input sheet is a customer form containing details for 1 customer. The customer details are pulled from the data tab using vlookups based on a value in cell a1 on the input tab.

Letters 1 & 2 are letters to a customer. They again use vlookups to populate various fields on the letters with the customer information on the input sheet.

What I need:

A macro to populate the input form by working down the records on the data sheet. when the input form is populated with customer information it is to export the letters as a pdf and then move on to the next row of customer details.

I have the export to pdf macro, i just cannot get the input form to loop through the customer records..

any ideas?

thanks in advance.

[Olly]

Something like:

Please Login or Register  to view this content.