I have a spreadsheet where sheet 1 is a customer statement, sheet 2 is a
form letter and sheet 3 has a list of customer numbers and customer names.

In the customer statement for example there is a vlookup that references a
value on the 3rd sheet (with the list of customers). So if the value is 3 it
will use the 3rd customer number in the list.

What I'm trying to do is have a macro run that will print the statement,
print the form letter, increment the value on sheet 3 by 1 and then continue
to loop through this process untl it reaches the end of the list on sheet 3.

Any ideas?

Thanks